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.
| Author |
Topic |
|
shajimanjeri
Posting Yak Master
179 Posts |
 Posted - 2007-05-26 : 02:16:37
|
Hi, Suddenly my ASP page becomes too slow to download.Two days back there was no problem. Speed also was good. For ODBC connection I used sql authentication mode instead of windows authentication, so does it will make any kind of problem..?Or any other reason is there?with regardsShaji |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-05-26 : 02:56:02
|
there are a great number of reasons why perf can be bad. what auth mode you use to connect is not one of them.did the proc your asp is calling change recently? does the proc use a cursor? are the tables involved properly indexed?
www.elsasoft.org |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-05-26 : 03:24:16
|
I didn't ask if the ASP changed. I asked whether the stored procedure in the database that your ASP is calling changed.
www.elsasoft.org |
|
|
|
|
|
|
ASP files too slow!