1. Aart Onkenhout
  2. PowerBuilder
  3. Tuesday, 5 November 2024 08:01 AM UTC

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

Who is viewing this page


There are no replies made for this question yet.
However, you are not allowed to reply to this question.