Best unofficial Apache Server developers community |
|
When using stored procedure is it faster to return a cursor back? or is it faster to use the out data parameter of the data type. or it really won't have any performance difference.
posted via StackOverflow
|
|
 
|
Depending on the amount of information you are dealing with. In smaller tables ie. less than 1,000 records, you won't notice a sizeable difference in time. However, in large tables, the general rule is to stay away from cursors unless it is absolutely necessary to use. I have always found stored procedures to be quicker. |