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
Сообщения: 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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25857
Quote
Aw: Extra Fields in DB Mysql structure and relations to Products

Now, no.

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.