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



There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.