|
| Iniciado por guest, 20,jul. 2016 11:32 - 7 respuestas |
| |
| | | |
|
| |
| Publicado el 20,julio 2016 - 11:32 |
Hello,
I have a procedure that runs through a list of about 300 rows of a table.
Each row executes a number of queries some multiple times with altered parameters.
The results of the queries are added to summary datafile
The problem is the first 20 rows take about 30 seconds then gradually it slows down to crawl by row 100 each row takes about 30 seconds each and then sown to virtually stopped!! If i stop the program the restart the procedure (it picks up where it was stopped) it flies and adds them really fast again.
Any ideas? I ve tried HFreeQuery.
Thanks ISO |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2016 - 12:16 |
Hi Iso,
I have the same kind of problems when executing a few queries many times. I have send a request to PCSoft with an example project, but they could not reproduce the problem (I included a description for reproducing the problem, but in their answer they didn't follow the description, so the problem was not clear). I have no solution, yet. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2016 - 12:51 |
Hi Stefan
I just read through your problem, yes sounds like its the same. if i remove the queries that are repeated it flies through,i don't think the HFreeQuery works!
i am now going to recreate each query thats repeated, thats how desperate ive become  |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2016 - 12:56 |
Hi iso,
do you encounter this problem in test or in runtime?
If in test, check the dynamic audit settings.
If this is enabled, disable it and test it again.
regards, Xavier |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2016 - 13:11 |
Hello Xavier,
Its in Test Mode, where do i find the Dynamic Audit Settings, cant seem to find it?
Thanks |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2016 - 13:21 |
Hi Xavier,
It probably is that, i ve installed and it works fine!
Many Thanks
ISO |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2016 - 13:39 |
Hi Iso,
you find the Dynamic Audit on the dashboard if you have added the pane. Right click on the dashboard, check 'Modification mode' on, then right click and add or delete options and check 'modification mode' back off. When you've added the Dynamic Audit pane, click on the arrow - right upper corner and there you can enable or disable it.
cheers, Xavier |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2016 - 14:15 |
| Got it, and it worked, many thanks |
| |
| |
| | | |
|
| | | | |
| | |
|