Extra Fields in DB Mysql structure and relations to Products

07.03.2013 15:01
#1
AlexeyR
Joomshopping forum user no avatar
Name: Alexey
04.02.2013
Posts: 2
Quote
Extra Fields in DB Mysql structure and relations to Products

Hello Team,
I have question about product DB conception.
If I add some extra field then I see "Extra_field_[id]" column in each product.
Thus I have all extra fields for all products. Is it good to performance?

If I have 5 categories with 4 different extra fields then it is about 20!!! columns in porducts.
And it is just for small shop. Can you use in future somethink like attribures logic?
Have you an idea to move extra fields and products relations in additional hash table?
Or maybe add to prodcut extra fields IDs with commas like categories in extra fields table?

Thank you for project!
Wish you success.
Alexey R.

 
08.03.2013 18:42
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16487
Quote
Aw: Extra Fields in DB Mysql structure and relations to Products

Now, no.

 
Copyrights MAXXmarketing GmbH. All Rights Reserved