topic Why are search results limited to only 100000 results when there are actually more results? in All Apps and Add-ons

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

raghu0463 — Tue, 13 Jun 2017 15:22:55 GMT

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 — Tue, 13 Jun 2017 15:41:12 GMT

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

otherwise, can we see what the search is?

raghu0463 — Tue, 13 Jun 2017 15:53:00 GMT

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

cmerriman — Tue, 13 Jun 2017 16:11:12 GMT

try adding maxrows=0 in your dbxquery

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

horsefez — Tue, 13 Jun 2017 16:52:54 GMT

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

raghu0463 — Tue, 13 Jun 2017 19:17:14 GMT

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