in reply to Re: Re: Re: Re: Question about properly laying out a database
in thread Question about properly laying out a database

You do access records by ID, because you make multiple indexes (dbm files) which are each using a different criterion of the search as a key. It's kind of a roll-your-own MySQL.

Isn't it also overkill?

Given the claimed upper bound of 500 records (which means be generous and assume an upper bound of 1,000), it's still going to take fewer reads (and fewer disk head movements) to suck in an entire flat file of search criteria than it would to search using multiple DBM files.

There's a point at which the multiple DBM approach is a win, but I suspect this application is far below that point.

  • Comment on Re: Re: Re: Re: Re: Question about properly laying out a database

Replies are listed 'Best First'.
Re: Re: Re: Re: Re: Re: Question about properly laying out a database
by perrin (Chancellor) on Dec 12, 2001 at 23:13 UTC
    Kind of depends on the size of the car records, but it could be. I missed the part about only having 500 records. It would be interesting to try DBD::Sprite and see how it does on this.