|
| WD 19: slow queries executing? |
| Débuté par Alena, 24 juil. 2014 16:22 - 4 réponses |
| |
| | | |
|
| |
Posté le 24 juillet 2014 - 16:22 |
Hi gentlemen
We have upgraded our Windev 14 to Windev 19, but now I must solve several unpleasant problems.
My project is really large and I work mostly with queries.
Now, in Windev 19 , executing of some queries is much slower than in Windev 14.
These are mainly queries with more "join", or with "Like" in Where statement.
When I simplify the query, the executing is more quick. But I have a lot of queries in my project and they worked ok several years.
Is there something what should I set to speed up the executing of queries?
Thanks for any suggestions
Alena |
| |
| |
| | | |
|
| | |
| |
Posté le 24 juillet 2014 - 16:41 |
Hi Alena
did you run the query optimizer? From what you are telling us, the new
engine is using a different strategy and may be in need of new keys.
Of course, you also need to run the statistic and optimization on the DB
itself (in the HF control center), and make also sure that your new HFCS
19 is currently configured (cache in particular)
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
NEW: WXShowroom.com is available: Show your projects!
More information on http://www.fabriceharari.com
On 7/24/2014 8:22 AM, Alena wrote:
Hi gentlemen
We have upgraded our Windev 14 to Windev 19, but now I must solve
several unpleasant problems.
My project is really large and I work mostly with queries.
Now, in Windev 19 , executing of some queries is much slower than in
Windev 14.
These are mainly queries with more "join", or with "Like" in Where
statement.
When I simplify the query, the executing is more quick. But I have a lot
of queries in my project and they worked ok several years.
Is there something what should I set to speed up the executing of queries?
Thanks for any suggestions
Alena |
| |
| |
| | | |
|
| | |
| |
Posté le 24 juillet 2014 - 18:05 |
Hi Fabrice
many thanks for info and your suggestions.
Basically, I know how to optimize queries etc., but I had not planned to do it when we've got new Windev...
Regards
Alena |
| |
| |
| | | |
|
| | |
| |
Posté le 25 juillet 2014 - 13:43 |
Hi Alena
well, it's just opening each query in the query editor and asking windev
if it needs new keys... so that shouldn't be too much of a problem
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
NEW: WXShowroom.com is available: Show your projects!
More information on http://www.fabriceharari.com
On 7/24/2014 10:05 AM, Alena wrote:
Hi Fabrice
many thanks for info and your suggestions.
Basically, I know how to optimize queries etc., but I had not planned to
do it when we've got new Windev...
Regards
Alena |
| |
| |
| | | |
|
| | |
| |
Posté le 30 juillet 2014 - 11:46 |
From an earlier post I remember this undocumented solution from the technical support
HExecuteSQLQuery(sReq,hOptimiseurV1,sYourQuery)
And yes, there is also hOptimizerV2
I never used it, but noted this in my personal knowledge database.
Maybe it helps.
Kind regards
Rudolf |
| |
| |
| | | |
|
| | | | |
| | |
|