Can query fetches be routed to a different database

From the the slow logs I see that and QUERY_AND_FETCH slow for queries. my understanding is this where the ES fetches the documents after it determines the ids in the QUERY phase.

I am thinking of keeping just ids in elasticsearch and move the document to redis , can i change elasticsearch to do the fetches from redis? or should I get back the ids from ES and then do a redis fetch?

You cannot do that.
Why would you want to anyway?

From the slow logs fetches seem slow, I am seeing this might be to do with disk IO so instead of storing the documents in disk in ES thought it will be better idea to use ES for searching /faceting/ filtering but the actual document fetch could be from in memory datastore

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.