jbhx4 — 2013-06-17T08:04:29-04:00 — #1
I have a 'client' field for a table project and I was going to use a select field to show all of the companies but as I understand it loading all of those records could be problamatic. Second choice was a popup dialog with a searchable list which would pass the id back to the form.
Is there a better way to do this or am I on the right track. Suggestions are very welcome.
parkint — 2013-06-17T08:14:36-04:00 — #2
Welcome, James, to Sitepoint. Thanks for providing a clear and accurate description of your problem. With the level of expertise here I am certain you will get a number of insightful responses.
To better clarify your situation, How many clients do you expect to be in the list of choices?
Is this data local on the client machine (is this a proprietary app where i have installed a client portion as opposed to a traditional Web app)?
jbhx4 — 2013-06-17T08:51:13-04:00 — #3
sg707 — 2013-06-17T14:08:35-04:00 — #4
To really help you, we'll need to understand much more on where the performance will be hit. Do you mean the display select fields or retrieving the select fields from back-end? Most of the performance issue is back-end and to solve this, you can do some smart caching. In terms of how... this is hard since we don't know what your back-end storage mechanism is. If it's really the front-end then you can use AJAX based selection field. If you don't know then google "ajax autocomplete". There's tons of examples.