|
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 |
| |
| |
| | | |
|
| | | | |
| | |
|