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.

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]

Reply via email to