Server-side cursor for big result sets
MySQL doesn't support server-side cursors (except for in stored routines).
However, there is away to actually implemented them inside the connector
using CREATE TABLE and LIMIT in SELECT statements.
Blueprint information
- Status:
- Not started
- Approver:
- Geert JM Vanderkelen
- Priority:
- Undefined
- Drafter:
- Geert JM Vanderkelen
- Direction:
- Needs approval
- Assignee:
- Geert JM Vanderkelen
- Definition:
- Approved
- Series goal:
- None
- Implementation:
-
Unknown
- Milestone target:
- None
- Started by
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
MySQL doesn't support server-side cursors (except for in stored routines).
However, there is away to actually implemented them inside the connector
using CREATE TABLE and LIMIT in SELECT statements.
The idea is to make a MySQLCursor which while accept only SELECT statements
and create a temporary table. The Connector will then fetch from the
temporary table using the fetch-methods. The advantage is that it is
possible to do other operations using the same database connection.
It could be useful for big result sets which you don't wan to ship right
away to the application.
The new cursor will be named MySQLCursorServ
in functionality and should only be used for SELECT statements.
