You are 1 of 23 Active ASP Visitors
 
 
  ASP Home  |  Resources  |  Write a Review  |  My Favor-Its  |  Login
Add to Del.icio.us  Add to StumbleUpon
 


 
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!

2014 ezd.com, All rights reserved
 

Google Analytics Alternative