|
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 |
| |
Overall Rating:
 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. |
| |
|
