I have a project where I have approximately 3000 people on my database, a number which is a growing.
One of my pages is assigning people certain positions in a event, this means entering people into specific fields within a form.
When I post my form I am capturing the ID of each person in each field and saving them into a database.
I’m currently using a jQuery Plug-in over top of a select box to enable searching.
A native Select box is too difficult to use based on the sheer volume of people 3000 people over 30 boxes.
The plug-in improves searching within each box but makes my page slow and clunky.
i’m looking for ways how I can quickly search my list.
Having 3000 rows over 30 boxes makes my page humongous, using Ajax every time makes for a slower experience.
I’m hoping they may be a way of using just one list stored in my page and calling it whenever a user starts typing?
perhaps a text box for user input and a hidden ID box?