Hey Powerbuilders and DataWindow-Designers!
I "designed" a datawindow and it looks very good. It has many PNG pictures to show informations in a graphical manner.
So far so good. But when I want to retrieve a larger amount of data, ist is getting awfully slow when I retrieve data for the first time in this screen.
Choosing an other datawindow and coming back its fast enough. It is not a problem of the retrieve, which is fast in any case.
I think, first time a chache is filled, also it depends from the PCs RAM. On a virtual machine with 4 GB memory you like kill the task.
Any tips to improve this behaviour?
Thanks for all tips!
Stephan
I ran the pure SQL-Statement before iSQL of SQL Anywhere and ist was pretty fast in parts of a second. In Powerbuilder the same query is about 25 seconds at the first time. Retrieving other data and coming back, it is now quick as expected, not even a second.
I tried to increase cache settings of the database from 2G to 4 G maximum, but no difference.
Setting Redraw to false, makes a litte difference, about 5 seconds.
best regards
Stephan
1. The time taken to run the query in iSQL and in DW [ PB IDE] should be almost same.
2. Check the same in the script, by adding required messagebox(es) before and after dw_1.Retrieve().
If the all the three times are same, then check other parts of the scripts that delays the result display.
If the issue is for the first time (after cold start), I too face similar issue, which my customers are accustomed to it, now.