4 ms·
Plus it does not accept joins. So you basically have to denormalize all your data before injecting into Elastic. It helps speedup things. But is a headache to
by lolive 6y ago
Plus it does not accept joins. So you basically have to denormalize all your data before injecting into Elastic.
It helps speedup things. But is a headache to manage on a day to day basis.
- rpedela 6y agoYeah. What I do is create a view that does all the joins then the middleware just needs to do "SELECT * FROM my_view". If the DB has good JSON support, I will also convert the data into an ES index request with SQL so the middleware becomes even simpler.
- lolive 6y agoLet’s say you have a mostly read-only DB (otherwise things are different). Does it work when the view is insanely big? [i am not an expert at DBs, so my vision of a big DB might amuse you, but let’s say I have millions of rows to assemble as a view].