Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Asynchronously calling a stored procedure from ASP

Author  Topic 

ppuar
Starting Member

28 Posts

Posted - 2001-12-17 : 19:33:20
Can someone please give me some insight on how to call a stored proc from asp asynchronously? I have a page that takes about 50 seconds to complete and I would like to reduce this down to about 5 seconds.

Thanks
Pardeep

smccreadie
Aged Yak Warrior

505 Posts

Posted - 2001-12-17 : 19:45:01
I'm not sure what you mean by asynchronously, but you can run a stored procedure in a job ahead of time to avoid the wait time or timeout on an asp page.

You can also consider some preprocessing for reports. Also make sure your indexes are appropriate.

Go to Top of Page
   

- Advertisement -