Hi,
We have two versions of our application, a 32-bit and a 64-bit version. The 32-bit version uses OLE DB to connect to the SQL SERVER 2019 database, the 64-bit uses MSOLEDBSQL19 (version 19) as there is (still) no OLE DB driver for 64-bit. Set options (e.g. ARITHABORT ON) are the same for both.
When doing a retrieve on a datawindow with a stored procedure as datasource within the 32-bit version it runs the first time in, for example, 1,6 seconds, the second time it runs in 800 milliseconds.
When doing the same retrieve within the 64-bit version the first time it takes 1,6 seconds too, the second time it still takes 1,6 seconds.
For a datawindow with a 'normal' select statement times are more or less the same.
Any ideas what could be causing this? Is there a specific dbparm property that must be turned on or off? I already tried all kind of combinations with staticbind and disablebind, none of them didn't make a difference.
PS: using MSOLEDBSQL19 with the 32-bit version gives the same result as the 64-bit version.
Regards, Aart
- Aart Onkenhout
- PowerBuilder
- Tuesday, 5 November 2024 08:01 AM UTC
There are no replies made for this question yet.
However, you are not allowed to reply to this question.
However, you are not allowed to reply to this question.