Support the ongoing development of Laravel.io →
posted 9 years ago
Database
Last updated 1 year ago.
0

Not answer to your question, but just wanted to share my experience with EAV.

As you know, EAV is slow due to its nature of multiple joining queries. It is hard to optimize EAV queries if you use ActiveRecord implementation of ORM such as Eloquent.

Creating EAV records in the D.B is not that slow, but the reading part is just slow because you have to join multiple tables.

I ended up creating a repository with raw db queries then used decorators to decorate the raw db query result for the user facing site. I used ORM objects to create records though since inserting is not that slow.

Last updated 1 year ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

andipower andipower Joined 10 May 2014

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2024 Laravel.io - All rights reserved.