combobox binding in ASP

[ramesh subbiah]

Hi Everybody, I have a ASP program that displays a combobox with nearly 50000 records. I have used MS-Access database. It takes nearly 4 minutes to 7 minutes to display the page over the net. Binding all the records to the combobox takes this much time. In order to solve this problem, I have used rsfast library of learnasp.com. That also takes very long time. Can any help me to solve this problem? Thanks in advance. ramesh subbiah E-Commerce India, Coimbatore

[Mohammed Derbashi]

How about encapsulating the generation code in a COM object that contains compiled code(C++ or VB), which is faster than the scripting code. Mohammed Derbashi Web Developer

[Nick Parker]

Mohammed Derbashi wrote: How about encapsulating the generation code in a COM object that contains compiled code(C++ or VB), which is faster than the scripting code. There is a design flaw in the application, even if you were to create a COM component in VB or C++ to allow early binding to objects which does increase speed he is still going to see a lot of time degradation in the load process. 50,000 entries into a Select box is way too many, even if the file were to be loaded directly on the LAN. I would deeply suggest refactoring the application and look at ways in which you can isolate or group specific numbers, then post back to the server to get another subcategory of numbers. There is not a lot that you can do to see any dramatic decreases in load time for an application loading 50,000 entries into one page. HTH Nick Parker

---

[Paul Riley]

Nick Parker wrote: There is not a lot that you can do to see any dramatic decreases in load time for an application loading 50,000 entries into one page. Especially in Access. I once worked for a company who was trying to use 1,000,000+ record tables in Access (the whole table, not just a few indexed records), that took HOURS to process. Paul

[Nick Parker]

Paul Riley wrote: Especially in Access. I once worked for a company who was trying to use 1,000,000+ record tables in Access (the whole table, not just a few indexed records), that took HOURS to process. All I can say is "Oh boy...." :(( Nick Parker

---

[Paul Riley]

Nick Parker wrote: All I can say is "Oh boy...." :laugh: That's not quite what I said when they told me. We have a smiley for that round here somewhere. Hold on, here it is: :wtf: :-D Paul

[Nick Parker]

Paul Riley wrote: We have a smiley for that round here somewhere. We need a *!Are You Out Of Your Mind!* emoticon. :) Nick Parker

---