You are 1 of 18 Active ASP Visitors
 
 
  ASP Home  |  Resources  |  Write a Review  |  My Favor-Its  |  Login
Share on Facebook Tweet this! Share on Google+ Share on LinkedIn Add to Del.icio.us   Add to StumbleUpon eee
 


 
Resource Menu
 Speed up ASP Processing Site: Planet Source Code 
2
Reviews
2
Favor-It
This is an article on techniques to speed up populating Comboboxes and Listboxes in Active Server Pages from any data source (SQL Server is used in the examples) using ADO and database specific SQL. Author: Leo Mrozek Code: ASP 3.0 & VBScript




User Reviews   
   Authentic (0)  Anonymous (2) 




      
Overall Rating:
Codango PHP, ASP .NET, JSP Scripts, Resources, Reviews
Click to Read Reviews
User
Rated
    
Using a Stored procedure whould get it down..    
Written by Anonymous User (#1402-57) from Minneapolis, MN   (Friday, February 15, 2002)
Strengths:   no comment  
Weaknesses:   no comment  
Details:   Using a Stored procedure would have returned the string in less than one second on a dedicated SQL Server BOX! Also, if you have a drop down list that gets used over and over, store it in an Application variable. You can then skip the trip to the database when the Application variable exists. But the lesson in SQL was nice.

Good article    
Written by Anonymous User (#1916-349) from Hampshire, UK   (Friday, February 15, 2002)
Strengths:   no comment  
Weaknesses:   no comment  
Details:   A very good article, worth a read. Only works for SQL server on ADO 2.5, however, so not suitable for all solutions.

 
Sponsor
 

 

 

 
   
  Link to Us  |  About Us   Advertise  |  Contact Us  |  Website Help  
Write a User Review Today!
Its Fun, Fast, and Easy!
Web site monitoring by Web Site Monitor - for Android

2014 InfoVertica, LLC, All Rights Reserved *