Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- one or many tables
- geder s dorf
June 16, 2005, 11:34 pm
rate this thread
Re: one or many tables
Agreed; one large table with an index on `category` is better for almost
I would recommend creating an index for the category field. That would
increase the chances that there is no significant performance cost for
using one table over multiple tables (depending on whether the queries
on category can make use of the index).
Geder does not specify what "better" means for his case -- that is, what
are his criteria. Usually I assume it's for performance of queries.
I can think of one case where you'd find a performance gain by storing
data in separate tables per category: dropping a table is usually
quicker than deleting a subset of rows from a large table. So if
deleting all records of a given category is the most important operation
to optimize, then creating multiple tables may be better.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum