From: Amir Hardon (hardon_at_nonexisting.hamakor.org.il)
Date: Wed 09 Jun 2004 - 16:50:49 IDT
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 linux-il-request_at_linux.org.il with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail linux-il-request_at_linux.org.il
This archive was generated by hypermail 2.1.7 : Wed 09 Jun 2004 - 17:01:08 IDT