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.
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].