0

Comboboxes with large datasets

asked 2009-07-15 17:05:53 +0800

klotzw gravatar image klotzw
33

Hello,

I have a 2 comboboxes within my call tracking application each of which contain large sets of data.
One contains 500 records the other about 3000 records. The initization of the combobox is very slow with this much data.

I tried to solve the issue by using the onChanging event so as they typed I'd query my database to return a smaller dataset
based on the first letter. This works okay, but sometimes the combobox does not return the onChanging event and they have to
click out of the combobox and then click it again to get it to work.

The users want autocomplete and autodrop so I have to stick with combobox instead of listbox which has paging.
How to handle large datasets with comboboxes and keep good performance?

Thanks,
William

delete flag offensive retag edit

5 Replies

Sort by ยป oldest newest

answered 2009-07-15 18:03:45 +0800

YamilBracho gravatar image YamilBracho
1722 2

paging...

link publish delete flag offensive edit

answered 2009-07-15 20:53:03 +0800

terrytornado gravatar image terrytornado flag of Germany
9393 3 7 16
http://www.oxitec.de/

updated 2009-07-15 20:53:46 +0800

Like Yamil says:
have a look here.

You can see such a real paging is working here . Have a look at search masks that are working as bandbox. With a little bit of designing you can changed them nearly like a combobox

usr/pwd = admin/admin

regards
Stephan

link publish delete flag offensive edit

answered 2009-07-16 03:33:51 +0800

SergeTk gravatar image SergeTk
193 3

TerryT i can't open your link it sai's security certificate is bogus!!!

As far as topic goes bandbox is a way to go for your requirements,you can put listbox inside bandbox and use paging!!

link publish delete flag offensive edit

answered 2009-07-16 08:13:00 +0800

terrytornado gravatar image terrytornado flag of Germany
9393 3 7 16
http://www.oxitec.de/

updated 2009-07-16 08:16:10 +0800

@SergeTK

try anyway!

The messages says only that the https Certificate is not registered anywhere. It's the default
from apache.
We have not a certified apache https Certficat. This costs money :-(

in app --> menu item order --> search customer (Bandbox with paged listbox)

Stephan

link publish delete flag offensive edit

answered 2009-07-16 15:43:13 +0800

klotzw gravatar image klotzw
33

I have begun to change my comboboxes to bandbox containing a listbox.
As the user types in the bandbox I update the listbox with paging to select the name similar to autocomplete.

Thank you for the recommendations.
William

link publish delete flag offensive edit
Your reply
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

Follow

RSS

Stats

Asked: 2009-07-15 17:05:53 +0800

Seen: 748 times

Last updated: Jul 16 '09

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More