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 |
|
SQLMark
Starting Member
18 Posts |
 Posted - 2009-09-24 : 09:32:31
|
| Hi all,I have a simple SQL Server 2005 performance question.In my db I have created a Table-Valued User-Defined Functions (about 100 rows of code that fishing data from tables...) and I call it inside my application every 10 seconds.Function execution is quite fast (about 2, 3 seconds.) but mostly, its return value is the same since no data has been changed in the tables.Does SQL Server leave in a sort of "cache memory" the previous value avoiding executing the function again or should I implement a similar optimization? Is this the right way? Any suggestion?Thanks.Mark |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
|
|
|
|
|
SQL Server 2005 performance question