2. ASPRunnerPro General questions
  3. To much delay passing from pages
This topic is locked

To much delay passing from pages

 		10/2/2012 11:45:33
ASPRunnerPro General questions
M
 marcove author

Hi,

My application developped with AspRunner 6.22 (use SQL server by ODBC), After 1 year, now have 2 tables with 100.000 records, and have to much delay, opening list_page (30 items for page) or advanced search page (it's wait up to 30seconds) before opening the page where I could select fields.
What could I do to reduce this delay?

Note that server machine works good.

Thank you

M
Sergey Kornilov admin 10/2/2012

Just in case make sure you don't have lookup wizards with large number of records. That would explain the slow search and list page issue.
M
 		marcove author 10/3/2012

Thank you,

but with so much records how could I haven't lookup wizard in serch pages?

M
Sergey Kornilov admin 10/3/2012

I'm not sure I understand your question.