Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combobox with large rowsource source slows response
Message
 
To
26/08/1999 06:40:22
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00257779
Message ID:
00257799
Views:
17
>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.
> Any suggestions?

Common wisdom is that's *way* too many items for a combo, a couple hundred is the most that can ever reasonably be used. I've found performance trouble at about 300 or so, myself. You'll have to look at other solutions, like a textbox to filter the combo input, something like that. If you have real estate problems, think about pages or a popup modal with a grid, maybe.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform