About graypacket

graypacket · ‎05-09-2020

hi @aakulov Thanks for your reply. I think I was not able to clearly explain the problem. Let's take an example, suppose I have 1M records for phone numbers. Here the frequency of phone number P1 is x and P2 is 2x (2 times x). My observation is that time taken in fetching same number of rows, let's say 10k, for both phone numbers is different (QTime is more in case of P2) even if I don't use any sort parameter. I want the QTime to be same if number of rows in both the cases is same.

graypacket · ‎05-08-2020

I have 1 Lac records indexing per day and I want to query records for last 7 days only. As per my understanding, when we query solr it fetches all the records with respect to the query and sort them in some order, in memory, and provides us the required number of rows. As I only want last 7 lac records, can they be fetched without touching the old records? What is the best way to do it?

Online	Offline
Last Visited	‎07-11-2020 05:53 AM

Member Since	‎04-29-2020 11:06 AM
Last Visited	‎07-11-2020 05:53 AM
Posts	5
Kudos received	1

Cloudera Community

Re: How to limit the number of records fetched by ...

How to limit the number of records fetched by Solr...