This topic is locked

"Print Whole Report" Timeout

3/18/2014 10:08:03 AM
PHPRunner General questions
S
shathcock author

So I have a report that is pulling probably 200 records at a time from a database of about 295000 records based on a date range search. The report displays to the screen perfectly with a query of about 7 seconds. The report is grouped and When I select the Print option for that group it works fine however when I select "Print Whole Report" it times out. I have tried increasing the time but it still just times out. Occasionally but rarely can I get it to print with a certain set of records based on a date range. Any Ideas?

Sergey Kornilov admin 3/18/2014

This might be the case of some indexes missing that leads to slow group query execution. Hard to tell without seeing your database structure and application.