From: Maxim Kovgan (maxk_at_nonexisting.hamakor.org.il)
Date: Wed 09 Jun 2004 - 19:04:17 IDT
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 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
>
>
................................................
Max Kovgan. .
email: maxk _at_ cs.technion.ac.il .
phone: 972-4-8294528 .
................................................
=================================================================
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 - 19:16:37 IDT