1. william yau
  2. PowerBuilder
  3. Tuesday, 14 September 2021 10:28 AM UTC

Hi Guru


   I upgraded powerbuilder  from 7.0 to Appeon 2019 .and SQL server 2000 t0 2019 but I found some program ,especially open word , slow than old version. Do me need to upgrade some driver for appeon 2019 ?


please advise me




Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 15 September 2021 15:07 PM UTC
  2. PowerBuilder
  3. # 1

PB2019R3 build 2703
Windows 10, 64 bit platform
Oracle 12.2, 32 bit client

After >>> MUCH <<< research, I found that when the DBPARM in SQLCA was set with "DisableBind=1", processing was at least 5 times slower that when the DisableBind was set to zero or just left off the transaction object.

However, when we set DisableBind=0, we started getting "All variables not bound" errors all over the place.

Our solution was to have DisableBind=1 for all visual processes, but for non-visual processing in the one main are where we really need the speed, we temporarily set it  to zero, then return the setting to 1 when we are done.

There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 15 September 2021 04:06 AM UTC
  2. PowerBuilder
  3. # 2


How slow is slow?

A lot of people have complained about the newer versions of Powerbuilder being slower (and they are), but many of the problems have been fixed by distributing a PB.INI file with the executable. (and for the IDE, editing the pb.ini used in powerbuilder too).

This is the contents of my pb.ini (only the bold text is relevant):


[DataStore Behavior]

[Data Window]



We are using Office 365 and Word opens "reasonably" fast, like around one second.

I'm not saying this will solve your problem, it might also have something to do with, for example, the settings of Word's "Trustcenter", where you can speed things up by allowing files to be trusted when on a network, etc. Also look if you don't have some addon which might be slowing down opening a document.


There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 14 September 2021 14:00 PM UTC
  2. PowerBuilder
  3. # 3

Hi William;

  Going from an ANSI (single byte) to a Unicode (double-byte) version of PB, the O/S and SS for that matter, can certainly make a difference. SS for example goes from UTF-8 to UTF-16LE encoding along with PB and the O/S. These changes just in themselves while adding more flexibility in handling the extended character sets, do add more processing overhead.

  I assume when you mention "Word" that you are talking about MS-Word. That is another aspect as well - MS-Office, as newer versions like Office365 add more over-head as well due to various factors like new features and 64 vs 32 bit operation. Even PowerBuilder 2019 Rx now can compile into 64 bit application EXE's that add more memory accessibility, yet can take a longer time to start due to the way the O/S handles the larger address space / memory allocating.

  In order to help you further though, we would need a lot more details on your environment, application structure, code snippets, compile settings, etc in order to provide more meaningful feedback.

Regards ... Chris


There are no comments made yet.
  • Page :
  • 1

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.