ADP Dynamic Combo Box is S L O W

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

ADP Dynamic Combo Box is S L O W

I have a combo box in which I am supplying the value list programmatically.
The combo box has 4 defined columns and is bound to the first column. If
the combo box has only a few entries all works just fine. But I have a case
where the combo box has 300 entries and it runs into problems. If the user
selects an entry early in the list all is well and good. However if they
select or type an entry towards the bottom of the list it maxes the CPU at
100 % and takes a couple of seconds to respond. At which point if you save
or undo again it maxes the CPU and takes about 15 seconds to respond.

Is my problem the relatively long Value List? For the 300 entries the value
list length is about 9000 characters.

Any ideas?
 
It was the long value list!

Why that was a problem I am not sure but I tested with a View instead of a
value list and it worked normally. Beacuse I am using Dynamic SQL against a
possible 4 related tables (4 related combo boxes) building the value list
maked sense. These related tables are based on Inventory types with each
type having a different definition of what possible 4 tables are in play.

Given this I still have a potential problem but I wanted to pass along the
knowledge.
 
Back
Top