Search speed slow using 'All Fields Search' vs 'Search Panel' |
2/28/2021 10:23:46 PM |
PHPRunner General questions | |
![]() 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? |
|
![]() |
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. |
![]() |
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
|
![]() |
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. |