On Wed, 9 Jun 2004, Amir Hardon wrote: > Hi, > I'm planning a DB structure for an e-commerce system, and facing some question > about the DB efficiency that I don't know how to approach. > > For example what will be better, storing all items information in one table > with one column for category, or having a separate items table for each > category. > My guess is that separate tables will be faster for use but will consume more > disk space. > > Where can I learn about this subject? I guess it also depends on the DB > backend I'm using, so for this case it is mySQL.
Once, several months ago, I was purrueing the same subject. the keyword is "Database balancing". I was pointed by someone to read on the subject. if you dig a year back in this list archives, on my posts, you shall find the answer. cheers. M. > > Thanks, > -Amir. > > ================================================================= > To unsubscribe, send mail to [EMAIL PROTECTED] with > the word "unsubscribe" in the message body, e.g., run the command > echo unsubscribe | mail [EMAIL PROTECTED] > > ................................................ Max Kovgan. . email: maxk _at_ cs.technion.ac.il . phone: 972-4-8294528 . ................................................ ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
