Subscribe for automatic updates: RSS icon RSS

Login icon Sign in for full access | Help icon Help
Advanced search

Pages: [1]
  Reply  |  Print  
Author Topic: Ask Reuben 106 - COMBOBOX Item Count  (Read 1910 times)
Reuben B.
Four Js
Posts: 1033

« on: January 21, 2022, 04:01:46 am »

When you click on a COMBOBOX to view the list of items to select from, that is fast.  The reason it is fast is because the items have already been sent from the back-end to the GUI client.  There is no database activity or values being sent across the network at this time because it has already happened.
Nothing is free and the price in this instance is that any database activity to determine the items available and network activity to send the list items to the front-end takes place on or before when the window/form is visible.
If you have a COMBOBOX with hundreds or thousands of entries to select from then that can lead to excessive and unnecessary database and network activity.  You should have a design standard to limit the number of entries in a COMBOBOX.

Product Consultant (Asia Pacific)
Developer Relations Manager (Worldwide)
Author of
Contributor to
Pages: [1]
  Reply  |  Print  
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines