Welcome! Log In Create A New Profile

Advanced

WD26 - sqlserver performance

Posted by ArieM 
WD26 - sqlserver performance
October 14, 2022 02:12PM
Hi,

WD26
SQLserver
native driver

I have a query which retrieves a bunch af records from a (Microsoft) sqlserver.
When I run the query in the Sql Manager the result are presented quite fast
When I run the same query from a Windev app, it takes much longer.
Both tools run on the same client (not the server itself).

In the windev test I don't even present the data on scren, Ijust run the query and perform a FileToArray() to get the result. And even it is slower

What could cause this differnece? Any ideas?

Arie
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: