asked on comma separated values or separate table
Hi,
we have 2 tables; product and accessories; a product can have multiple accessories.
which approach is faster & better
a. store the accessories id as a comma separated value in the product table
b. create a separate table and store the relationship
b. 1 table columns: product_id,accessories_id (composite primary key)
b.2 table columns: id (primary key),product_id,accessorie
Thanks
/govind
we have 2 tables; product and accessories; a product can have multiple accessories.
which approach is faster & better
a. store the accessories id as a comma separated value in the product table
b. create a separate table and store the relationship
b. 1 table columns: product_id,accessories_id (composite primary key)
b.2 table columns: id (primary key),product_id,accessorie
Thanks
/govind
Web DevelopmentDatabasesMicrosoft SQL Server 2005
Last Comment
govindarajan78
Ofcourse the option b
SO Basically you'll have 3 tables
products ---> prod_id (prim. key),name
accessories---> acces_id (prim. key),name
product_accessories ---> id (prim. key),prod_id,acces_id
SO Basically you'll have 3 tables
products ---> prod_id (prim. key),name
accessories---> acces_id (prim. key),name
product_accessories ---> id (prim. key),prod_id,acces_id
ASKER
i am more worried about fetching the record; which is relatively faster? how?
Hi govind,
Your question is good debate question.
For me, your questions answer depends upon a configuration you are using for client/ server.
For me option 2 is best practice and good approach.
Both will take approx same time depending on the amount of data.
Larger amount data is directly proportional to Option 2 as a solution.
Thanks
Your question is good debate question.
For me, your questions answer depends upon a configuration you are using for client/ server.
For me option 2 is best practice and good approach.
Both will take approx same time depending on the amount of data.
Larger amount data is directly proportional to Option 2 as a solution.
Thanks
ASKER
Hi smash73,
the data are growing to grow to thousands.
in the option b which one is better
the data are growing to grow to thousands.
in the option b which one is better
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
can anyone explain how b.2 is better than b.1 at execution level
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks a lot
This is more convenient and easy to store and fetch the records.