Best way to handle large list of results in recordsets?
Hello all.
I'm using Dreamweaver CS3, MySQL and ASP/VBScript.
My database of users behind my website is now approaching 25,000.
I often have to "move" items in the database from one user record to another.
Up and until now, I've done this simply by way of a drop down menu/list that is populated with the user ID# and Name of each and every user in the database. This previously allowed me to simply select the ID of the Customer I wanted to "Move" the record to.
The problem, is that the system is of course now trying to load a list of almost 25,000 user ID's each time I view the relevant site page, which is now taking so long to load it's uncomfortable.
I've seen other sites that allow you to start typing something in to a text box and it starts filtering the results that match as you type, showing a list below.
I assume (but am happy to be advised otherwise) that this is likely to be my best way forward, but I haven't the first clue how to do it.
Can anyone advise?
Regards
David.
