|
|
Posted by Eric Fortier on 06/28/05 20:20
Hi all.
I'm building a database to keep track of users and their products. The number
of users is expected to always increase (hopefully ;) and each user can add any
number of products to their account.
The product definition will have several fields and might take several
kilobytes of space (title, short and long description, etc).
I have a user database that keeps track of all user related information, like
emails, address, etc. What I was puzzling over was how to store the products
for each users. Creating a "products" table for each user was my first thought
but I'm not sure it's the best way to go, especially when thousands of users
will have an account.
Another idea was to create a global "Products" table and place all products for
all users in there with an identifier for doing lookups. Again, I'm not sure
this is the right kind if approach.
Drive space is not an issue, but quick delivery of product infos to viewer is.
Any suggestion?
Thanks a lot,
--Eric
http://www.tlnewsreader.com
Navigation:
[Reply to this message]
|