I am using ScriptCase 9. I just started using it. I am using MySQL database. My question is “”. There are 70,000 records. The grid is running very slowly. I am waiting for 3 minutes when I do dynamic grouping. Even grouping, then the summary is locked on the buttock.How could you suggest me to propose a solution.
I have the same problem with version 8.1. Did you solve the problem?
A few considerations. Why are you displaying a grid with 70.000 records. No user will look into that. To generate dynamic grouping (as the names says) there needs to be severe database access on each change. I can’t tell, but it sounds to me as a design issue. So try to limit the resultset to a pool that is useful to the user (who can only see a handful of lines on each page).
Dear Albert,
I created 2 forms (master / detail), the detail takes a long time to display 49 rows (43 seconds), and the same query in the database takes 0.003 seconds (attachments masterdetail1.png y masterdetail2.png).
I have created a test form with the same query to the database to obtain the 49 records, however it is very slow (92 seconds). I have tested on multiple servers (environments) with the same result. I have configured on the production server (Xeon E5 2673 (2 CPUs), 14GB RAM) files php.ini, my.ini, and database level I have created indexes in large tables. Is there a problem with version 8.1.066? Can you give me the proper php.ini / my.ini settings (Although according to the time of obtaining from the database is minimum, attachment masterdetail3.png)?
Best regards,
William
