I have a similar structure in my database where advertisers can create their
own ads on my accommodation website. I have 7 different categories of
advertisers on my site eg: accommodation businesses; tourist attraction
businesses; local transport businesses etc
Each advertiser chooses their specific category and then their ad is added
to that specific categories table
I have recently upgraded to sql7.0 and there has been no problems using the
structure indicated above. Please feel free to visit my website
www.australianaccommodation.com to view the functionality of the site.
Kind Regards
Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Email: [EMAIL PROTECTED]
Developers Of:
Website: www.AustralianAccommodation.com
Website: www.AccommodationNewZealand.com
----- Original Message -----
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 07, 2000 12:53 AM
Subject: Database Question???
I am setting up a website in which people are creating records and storing
them in a database (Access 2000 at this time). Am I better off with a
single table that includes all of the records of all users or should I set
up a seperate table for each user? I am pretty sure that the seperate
tables would have better performance but will probably be harder to upgrade
to SQL 7 later. Please let me know your opinions.
Thanks,
Rich
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
