Currently I have MySQL tables with and SQL queries in my code. I have one column, where JSON data is stored and MySQL performance is very bad with it. So I moved it to ElasticSearch, which speed suit me. But now I have thousands of row ID from ElasticSearch and I don't want to feed them into SQL query (I think feeding 10k IDs just to fetch one row is inefficient). Also, I can't use ElasticSearch to fetch all data, because it doesn't support OFFSET, that I'm using for pagination.
What should I do to have sufficient performance and not move all search to ElasticSearch (rewrite half of the code)?
