Powerbuilder 7.03 DropDown Datawindow slowness

Posted on 2004-10-28
Medium Priority
Last Modified: 2013-12-26
I have a DropDown DataWindow which allows editing.  There are several thousand results in the result list and that populates fairly quickly, but when you manually type in the field it is painfully slow and there is a noticeable pause between keystrokes as the DropDown scrolls to keep up.
I am new to Powerbuilder any suggestions would be much appreciated.
Question by:booksplus

Assisted Solution

michaelstoffel earned 720 total points
ID: 12434078
I wouldn't use a dropdown.  Several thousand is useless for a user to actually scroll through.  How about opening up a lookup window with some search capabilites?

Author Comment

ID: 12434234
The users almost always know what to enter and just want to type it in quickly (and have the occasional convenience of a drop down to help in the search).   Unfortunately, its not practical for me to spend too much time on this.  The users would be willing to pay the performance price somewhere else just as long as it doesn't slow down their typing.  Thanks.

Accepted Solution

michaelstoffel earned 720 total points
ID: 12434879
So, how about just having it as plain text entry with a possible lookup window.  Then validate their entry upon saving?
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 18

Assisted Solution

diasroshan earned 60 total points
ID: 12435133

can u post the code u have written in the editchanged event for that datawindow...
maybe the code can be optimised and speed ur work...


Author Comment

ID: 12435946
There is no "editchanged" event on the DataWindow.  There is an "itemchanged" event that fires after the user tabs out.

I had hoped that turning off  the "Edit.AutoVScroll" property on the drop down would fix the problem, but it seems to completely disable the drop down capability.  I'm not sure if this is a PowerBuilder bug or my inexperience.

Author Comment

ID: 12437267
Also -

I can see all the results (very quickly) in the dropdown by scrolling - BUT it takes long for Powerbuilder to scroll to the result when the user manually enters their chioce.

INCREASING points by 50.  

Author Comment

ID: 12437935
This is urgent - increasing points to 500.
LVL 10

Assisted Solution

Sys_Prog earned 60 total points
ID: 12440437
Can u post code in all the datawindow evetnts.

Specially fo these events

1. ItemChnged
2. ItemFocusChanged
3. Initial Population of dw
4. structure of dddw
5. EditChahnged event


Assisted Solution

EdMacke earned 60 total points
ID: 12493888
Does the dddw retrieve sort the result set - I'm wondering if every time you enter a character PB has to search the entire list (something that would be easier / unnecessary if it was sorted)?

Also, I know this sounds stupid, but do you have the horizontal scroll bar enabled?  I've run into problems exactly like you described with hscroll enabled, but it was usually with listboxes.  Give it a try, just to see.

I would also echo others' sentiment that a dddw with 1,000+ items isn't the best idea from a GUI design standpoint.  I can see why you're doing it, but maybe there's another way?

Good luck

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In our object-oriented world the class is a minimal unit, a brick for constructing our applications. It is an abstraction and we know well how to use it. In well-designed software we are not usually interested in knowing how objects look in memory. …
Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question