Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
Does anyone know any way round this?
Have you confirmed that it's the actual query taking so long or might it be the processing of the ASP page as well? Depending on exactly what you're doing, it might also make sense to move the query from ASP into a stored procedure.
Another thought- does your DB server have enough memory/processing power? And are you using separate servers for your web server & SQL 2000?
[edited by: LifeinAsia at 3:24 pm (utc) on Aug. 23, 2006]