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 |
|
kumarich1
Yak Posting Veteran
99 Posts |
 Posted - 2008-09-02 : 16:41:10
|
| Hi,I have a procedure in development(2000) environment and same procedure in production(2005). Procedure in development is taking 1 sec whereas in production it is taking 12 - 15 sec. When I did some testing on this issue, I came to conclusion that procedure is slow because of function ,I removed function and replaced it with script in the procedure in production, then procedure is running fast.Why procedure is fast in development(2000)?Why procedure is slow in production(2005)?When I replaced function with script , procedure in production is taking 2 sec, I am just trying to understand why function is slowing the procedure. BTW function is returning about 2000 records .Is it a good idea to use functions or avoid them whenever possible.Please advise |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-03 : 06:03:18
|
How are your indexes? Are they up to date? Reorganized and ready to be used?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2008-09-05 : 16:47:23
|
| Yes indexes are up to date. |
|
|
|
|
|
|
PROCEDURE taking too long