Hi there,
I am trying to get about 1.5 million document which includes less then 6 field from elasticsearch index to .net app and it is unreachable, super slow. Is there any way to get such number of documents in real time using nest api ?
Hi there,
I am trying to get about 1.5 million document which includes less then 6 field from elasticsearch index to .net app and it is unreachable, super slow. Is there any way to get such number of documents in real time using nest api ?
Are you trying to load 1.5 million documents into memory in an app?
Yes, because I need some joins over returned documents and elasticsearch does not have sql like temporary tables
Loading 1.5 million documents to join data in memory is going to be challenging, irrespective of the data store.
It’s possible to get 1.5 million documents out of Elasticsearch using the .NET client’s observable ScrollAll()
helper method, but you may want to consider denormalizing the data that is being joined, to persist it with the documents.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
© 2020. All Rights Reserved - Elasticsearch
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.