Hi there...

I have got a heavy report which will be run under web (IIS 5.0 & ASP)

but when I run it, it takes several seconds to run and after running it, the web server will be down...I have used "stored procedure" for its query inorder to optimize it ...but it seems that it's not benefit.....

what is your opinion? what can I do for it? is there any solution ?

thank you