I am designing a web page. The main page is divided into 3 frames. 2 of 
them are linked to htm files only. However,the main frame of this web 
pages require to call a asp page. Everytime, the content of the 2 htm 
files come first..and the content of ASP page need lot of time to load it. 
This ASP page is connected to a database which called 1000 records 
everytime. How can I speed up the loading of this ASP page?


Thanks.

Use GetRows()
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=190

Limit the number of records returned to only those you need, using a WHERE
clause in your SQL statements.

Use Stored Procedures.

-Kim


> -----Original Message-----
> From: ozgen [mailto:bk_mandyt@d...]
> Sent: 8. september 2002 14:30
> To: ASP Databases
> Subject: [asp_databases] how to speed up the loading time ?
>
>
> I am designing a web page. The main page is divided into 3 frames. 2 of
> them are linked to htm files only. However,the main frame of this web
> pages require to call a asp page. Everytime, the content of the 2 htm
> files come first..and the content of ASP page need lot of time to
> load it.
> This ASP page is connected to a database which called 1000 records
> everytime. How can I speed up the loading of this ASP page?
>
>
> Thanks.