Well, if you already know that you need to display only the first 20 records, why not only search for them? Or if you don't know whether they already exist, search for, say, a hundred, then thousand and so on until you have enough.

Nevertheless, what's really needed for a good answer or ideas on how to do what you need, is where this requirement comes from. I guess the main question is: WHY do you need to search for millions of IDs?

--Ere

5.1.2016, 16.12, Mugeesh Husain kirjoitti:
Thanks for your reply @Ere Maijala,

one of my eCommerce based client have a requirement to search  some of
records based on ID's like

IP:8083/select?q=ID:(1,4,7,.......upto 1 Millions), display only 10 to 20
records.

if i use above procedure it takes too much time or if i am going to use
solr-terms-query according to yonik blog http://yonik.com/solr-terms-query/,

then i am getting 122,119 microseconds with a Solr Terms Query.

I am looking for an response around 50-150ms.





--
View this message in context: 
http://lucene.472066.n3.nabble.com/how-to-search-miilions-of-record-in-solr-query-tp4248360p4248657.html
Sent from the Solr - User mailing list archive at Nabble.com.


--
Ere Maijala
Kansalliskirjasto / The National Library of Finland

Reply via email to