We have a project in regular ASP - using MS SQL database - inventory table with about 20 fields. On a form we have a list box that fills the stock number and item description from that table - we currently have about 10,000 records in that table.
We have a text box above the list box and trying to create the ability to start typing the stock number into the text box and the listbox responds by going to the first record with the first number and then the first record with the first 2 numbers, etc. as you type - so by the time you get to the last digit you should be at that item. Our problem is the current code loops through all the records and is just W A Y T O O S L O W !!!
We are looking for someone that can provide a demo of how to speed that up so it is almost instant and they can just type the number in and it will respond in real time.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).