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

Question

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

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?

asked Mar 22, 2019 by Frank | 4 views

2 Answers

Related questions

TimTowdy · Answer 1 · 2019-03-24T15:15:40+0000

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.

Frank · Answer 2 · 2019-03-24T15:15:40+0000

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.

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

Please log in or register to add a comment.

Please log in or register to answer this question.

2 Answers

Please log in or register to add a comment.

Please log in or register to add a comment.

Related questions

Most popular tags