hello.
I am trying to connect ELK search with my existing SQL Server ecosystem.
I have created a CLR that calls Elastic index with search parameters (using native POST request) and then convert (deseriale) the results hits into result set.
It works great.
The expected result is just the document_id (_source: false) because the index is being created using the same as SQL server table.
The thing is, when the results list (hits) are 120,000, it takes time for this json to be downloaded from the index (might take 10 seconds).
Any ideas how can i imporve that?