Is it possible to do without Entity-Attribute-Value?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
4 views
You need to make something like a online store. The problem is choosing a method of storing information about goods types of goods over hundreds and each of them has its own range of attributes.

The same Magento Commerce for these purposes uses the EAV structure, where the select queries are much more complicated and don't work very quickly. So far the only idea — to periodically convert EAV to a normal table from which you will be sampling. Is there a more efficient way within MySQL or PostgreSQL?

Also in the process of searching for the answer to this question is not met the opinion that in this case is to abandon the relational database and go to noSQL. How is this true and will it run faster?
by | 4 views

2 Answers

0 like 0 dislike
The problem with EAV is that each field is independent of the object. I.e. the sample of 10 objects of 10 fields, will make about 100 random seek. Solution:
1. Memory tables — fast random seek, the limited size and the need for synchronization with real data.
2. Sphinx and the like. Alternatively, the stored data in a format more convenient for the facet search.
3. nosql is easier to scale, data are often stored in memory, lack of schema, but with the ability to create indexes on fields.
by
0 like 0 dislike
You can try the option of the entity, which has: a shared identifier fields (such as cost and availability), the search field (concatenated attribute values through the wild delimiter) field with XML (or any other format) in which to store all the information.
by

Related questions

0 like 0 dislike
1 answer
0 like 0 dislike
2 answers
0 like 0 dislike
1 answer
asked Apr 9, 2019 by OgecuT
0 like 0 dislike
3 answers
asked Apr 1, 2019 by MUTOgen4eg
0 like 0 dislike
2 answers
asked Mar 25, 2019 by Fesor
110,608 questions
257,186 answers
0 comments
27,970 users