Why are search results limited to only 100000 results when there are actually more results?

[raghu0463]

Hi,

When i run a search i was able to see only 100000 results but actually it as like 170000 results. I don't know why its giving less number of results.

[cmerriman · Accepted solution]

what is your search command? chart or timechart? use limit=0 to eliminate the limit.

otherwise, can we see what the search is?

[raghu0463]

im running the search in db connect, i didn't use any chart or timechart

[cmerriman]

try adding maxrows=0 in your dbxquery

my typical dbxquery looks like this:
|dbxquery connection=DB shortnames=t maxrows=0 query="select ....."

[horsefez]

go to db-connect app folder under local and edit inputs.conf where you can find the parameter "max_rows" as well

[raghu0463]

thanks, now im getting all the results but unable to load it to the database ..