This topic is locked

Search speed slow using 'All Fields Search' vs 'Search Panel'

2/28/2021 10:23:46 PM
PHPRunner General questions
need2sleep authorDevClub member

If I'm using the search directly from the list page (top) the searches take way too long for some reason. If I use the the search panel on the left side, they are almost instant. I was wondering if anyone has any suggestions on why it may take longer using one over the other?
There are about 4,000 records with 20 fields.
To narrow down the issue, I only selected 2 search fields for each type of search in the "Search and Filter settings..."
For example, I selected "ClientID" and "ClientName" for 'Search panel' and 'Include into All Fields Search' columns.
The search bar on the left shows both fields. If I use one or both fields during my search, the results are instant.
If I search using the search bar at the top of the page, it may take over 15 seconds.
I almost feel like the top bar is searching every single field even though it's only returning the results from the selective columns.
I have 'highlight search results' and 'show search suggest' enabled. No other options enabled.
Has anyone come across this before and what can I do to improve the search speed of the top search bar?

Sergey Kornilov admin 3/1/2021

The top search bar (basic search) will search across all fields that are marked as 'Include into All Fields Search'. Uncheck those fields that you do not need to be searchable.

https://xlinesoft.com/phprunner/docs/choose_fields.htm#search

need2sleep authorDevClub member 3/2/2021



The top search bar (basic search) will search across all fields that are marked as 'Include into All Fields Search'. Uncheck those fields that you do not need to be searchable.

https://xlinesoft.com/phprunner/docs/choose_fields.htm#search


Thanks for the response. The issue is even with just two fields selected such as "ClientID" and "ClientName" the search results take way too long.

Sergey Kornilov admin 3/2/2021

Enable SQL debugging and see what kind of SQL query is produced in both cases (fast and slow). This will point you in the right direction.