1. Miller Rhodes
  2. PowerBuilder
  3. Thursday, 4 June 2020 19:12 PM UTC

I just migrated an application from Powerbuilder 6.5 to Powerbuilder 2019 R1.  This application uses a treeview control which loads in about 18000 records from a datawindow.

I noticed that it loads pretty quick in the old application ( around 6 secs ), but it takes around 40 secs in the migrated application. Has anyone else experienced this ?

 

Do you have anything to suggest ?  ( I am looking at filtering , etc.. but maybe I could speed it up too )

 

 

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 4 June 2020 19:32 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Miller;

  There would be some degradation as you are moving from a single-byte (ANSI) version of PB to a Double-Byte (Unicode) version. However, does your TreeView Code ...

1) Use the SetReDraw (TRUE/FALSE) command on the tree-view while loading

2) Load the TV control that has no sorting active (use DW or SQL to sort instead)?

3) Use the InsertItemLast() command to load?

HTH

Regards ... Chris

Comment
There are no comments made yet.
Miller Rhodes Accepted Answer Pending Moderation
  1. Thursday, 4 June 2020 19:53 PM UTC
  2. PowerBuilder
  3. # 1

Thank you Chris

1) Use the SetReDraw (TRUE/FALSE) command on the tree-view while loading - Just added this and that solved it

2) Load the TV control that has no sorting active (use DW or SQL to sort instead)? Was doing this

3) Use the InsertItemLast() command to load?  I am doing this too

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 4 June 2020 21:04 PM UTC
That is awesome Miller ... I am super glad that tip#1 worked for you! :-)
  1. Helpful 1
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.