Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combobox with large rowsource source slows response
Message
From
26/08/1999 08:00:45
 
 
To
26/08/1999 06:40:22
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00257779
Message ID:
00257797
Views:
13
You may want to use another control than the ComboBox. It is normal to experience slowdown with a big list.

IMHO, ComboBox should be limited to no more than 100-500 items. Do you really want to scroll a 2000 items list to find the item you want?

>I have a form with a number of controls (comboboxes and listboxes) which is used to populate a table (that is control-source for these controls). PROBLEM is that form's response is VERY slow because of size of ROWsource for two comboboxes on form. (Rowsource is a table of about 2,000 records.) Slow behavior exhibits both upon creation of form and upon interactive drop-down of combobox list.
> The rowsource table is included in the forms dataenvironment, and is indexed (regular) by the fields used as rowsources in the combobox. I've tried using rowsourcetype-6 (fields) and specifying the to-be-displayed fields in the combobox's rowsource property, and I've tried rowsourcetype-3 (SQL-select) and selecting to a cursor in the rowsource property; both yield similar, SLOW results. There is no filtering involved -- all records are being shown.
> Users will need to use the combobox control every time they use the form, so a workaround suggested in MS' DevGuide -- viz., setting the rowsource dynamically in the gotfocus event, rather than statically -- wouldn't be of much use.
Previous
Reply
Map
View

Click here to load this message in the networking platform