Skip to main content
December 7, 2009
Question

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.

This topic is closed to new replies. Start a new post to keep the conversation going.

1 reply

Participating Frequently
December 7, 2009

You're looking for a 'type ahead' control. Try searching the web, although you may have trouble finding example code for classic asp. I did find some asp.net solutions out there.

Translate