In general, a Client-Library cursor performs worse than an equivalent select statement that is executed using a language or RPC command. An application that does not require the special benefits listed above achieves higher performance using language commands or RPC commands.
However, cursors may improve performance when the application would otherwise require several connections or some sort of row-buffering mechanism to accomplish the same task.
