[thelist] DB tables

[Adrian Fischer]

Hi gang,

So..what would be faster for a db backed auction?  Lots of  Tables with all
similar items in them or one table with all items in it.

Im thinking lots of tables because then at least the db only has to find an
item in a given table as opposed to searching through one giant table for
like item types.

But what about when you wanted to find all items that have a particular
price range or that end within a certain time?  You would then have to
search all the various item tables to find ones that matched the criteria.
I assume that would be slow?

Is there a happy balance or is it a trade off.

Your thoughts would be appreciated.




Adrian Fischer