2. PHPRunner General questions
  3. Long Lookup Searching
This topic is locked

Long Lookup Searching

 		11/26/2020 10:20:11 PM
PHPRunner General questions
J
 jackwood author

I have create application for payment system,

when I Lookup the record in All Search Field (only 2 Columns that reads the Data (OrderID and Customer)) for the outstanding payment it need more than 1 minute to show the records (Very Long).

But If I try select from database, it need 0.0820 Seconds to show the Data (Very Fast)
is there any way to Improve the Searching Trick ?

I have indexes 2 Columns in Database, but still heavy loading, Please help.

woodey2002 11/27/2020

Have a look here!
https://www.youtube.com/watch?v=-KX7o2jNdDk
Cheers,

J
Sergey Kornilov admin 11/28/2020

You need to turn on SQL debugging to what exactly takes so long. Copy the exact search SQL query, run it manually and it will point you in the right direction. You might need more indexes or you might need different indexes.