| Cursor [message #372447] |
Wed, 14 February 2001 02:44  |
syslam
Messages: 1
Registered: February 2001
|
Junior Member |
|
|
|
Within the cursor declaration, if I put some function inside, will it be any performance impact on the process if there will be over 2000 times of cursor loop ?
|
|
|
|
| Re: Cursor [message #372455 is a reply to message #372447] |
Wed, 14 February 2001 03:53  |
John R
Messages: 156
Registered: March 2000
|
Senior Member |
|
|
Well, it will execute the function 2000 times.
If the function accesses the database, there could well be performance implications.
If you are using 8.1.6 or higher, and the function does not access the database, you can declare it as 'DETERMINISTIC', which will improve the performance some.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
