MySQL Forums :: Database Design & Data Modelling :: Database efficiency question


Advanced Search

Database efficiency question
Posted by: denis k ()
Date: January 04, 2011 10:46PM

Greetings everyone,

Having an issue with the creation of my schema.

I have 2 tables: Customer, Product

I need to keep track of which product each customer has. The website will be checking on each login which product the customer does not have and will display it to them.

I have 3 options:

a) create a seperate table to store all the product IDs and customer IDs
b) create a prod ID for each customer and do a select from product.prod_id where there is not one in customer.prod_id
b) create a cust_id in product to do the same as b)

Which of the 3 would be less strain on the database?

Thanks in advanced!

Options: ReplyQuote


Subject Written By Posted
Database efficiency question denis k 01/04/2011 10:46PM
Re: Database efficiency question Rick James 01/06/2011 09:11PM
Re: Database efficiency question denis k 01/07/2011 11:18PM
Re: Database efficiency question Rick James 01/08/2011 12:59AM
Re: Database efficiency question denis k 01/08/2011 10:02AM
Re: Database efficiency question Rick James 01/08/2011 10:38AM
Re: Database efficiency question denis k 01/08/2011 11:02AM
Re: Database efficiency question Rick James 01/16/2011 03:30PM
Re: Database efficiency question SEO Innoexcel 01/15/2011 03:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.