Datawindow N-UP slow performance

[Former Member]

Hi everyone ,

I have a bit confusing performance problem with N-up datawindow , hope someone can help with with ideas

The extact Problem is :

     Datawindow is [slow] while doing : a click , item-focus-changing , row-focus-changing:

     Example : It takes a second ( bit more or less ) just to move from one field to another

     This happen when I run from executable app. file .

     But it's [Fast] when I run from Powerbuilder IDE

Here's is how I created this datawindow :

1. Iam using PowerBuilder 11.5 , back end is SQL server 2008.
2. I Created N-UP datawindow with 45 rows per detail band.
3. Datawindow retrieves around 2000 rows.
4. Datawindow has many (simple) expression to change the back color of columns ( which are my 45 N rows per detail ) based on data fields retrieved.

Things I have tried :

I removed all script from the above related events - NO EFFECT

I simplified the expressions of row to do color changing ( replace RGB with a number ...etc )- NO EFFECT

I removed the expressions - NO EFFECT !!!

What else I should try or do ?!

Is it about the native behavior of datawindow itself , or something is wrong with what i did ?!

Regards,

Ahmed

[Former Member · Accepted solution]

Hi Ahmed;

  A known issue with N-Up DW's being slow has been linked to the transparency on columns being set to 100. It has been reported that setting this value to 0 cured the performance problems.

HTH

Regards ... Chris

[Former Member · Accepted solution]

Just like Magic , It worked when I set all transparency to 0 !

Thanks a lot Chris

Has this problem been solved in the newer versions on Powerbuilder (12 and above ) ?!

[Former Member · Accepted solution]

Excellent news Ahmed!    

AFAIK ... Its still an issue in PB 12.6.  

[arnd_schmidt]

Wow! This only happens during runtime?!

That's definitively my "Pick of the week!".

[Former Member]

Hi Arnd;

   Yes, that has been a little known obscure bug in PB for quite some time. If you didn't know this little quirk existed though, you would be pulling your hair out trying to get this one resolved!  😉

Regards ... Chris

[arnd_schmidt]

@Chris,

and again: To the beloved datawindow  .. "No Hug todayiiieh, my love has gone awayiiieh ..."

[Former Member]

ROFL!

Actually, it was right after hugging an N-Up DW a long time ago that it whispered to me " pssst ... Chris, if you set my transparency to zero I'll work much better! ". So just in case, I always hug my DW's.  

[Former Member]

Thanks everyone for replying & ideas , the problem was just the transparency of fields has to be zero ! , Can't understand why , it seems a PB issue .

[Former Member]

Hi Ahmed,

I suspect it is doing lots of redraws.

You could try a quick and dirty:

In the ItemChanged event at the top of the event SetRedraw ( FALSE )

Right at the end of the ItemChanged event POST SetDraw (TRUE)

Similar in ItemFocusChanged, RowFocusChanged and even the Clicked event

HTH

Lars

[arnd_schmidt]

If you have this slow performance only while you are running the executable,

make 100 % sure that the exe is really using your simplified datawindow and code.

Is this all happening on your machine? Is there a mismatch in the PowerBuilder Runtime DLLs?

Also use Process Monitor to check if the exe is doing some weird action.
Tip: Set a filter to monitor only your xyz.exe.

hth

Arnd