This topic is locked
[SOLVED]

Slow response on search page

6/14/2021
PHPRunner General questions
R
RBrogen author

Hi Everyone,

My PHP Runner app is backended with MS SQL. I run a search on the SQL server direct and it is instant results but when I search from my Orders page in my PHP Runner App it takes up to 60 seconds to respond and sometimes even times out. I've reduced the serch options down to the ID field to test to see if it had something to do with that but it is still very slow. Any thoughts on how to get this resolved would be greatly appreciated.

Thanks in advance,
Randy

R
RBrogen author 6/14/2021

I appear to have resolved this issue by removing all search fields, republishing and then reselecting my search fields. It did introduce another issue which I'll post in a seperate topic that it highlights the search result in red but it does not filter the view so only the search results are displayed.