Learn about Linux
Download Linux
Get Linux helpSpecial Offers
Newsvac
Comparing Cursor and Set Approaches in Processing Relational Data
September 18, 2008 (5:30:00 PM) - 1 year, 2 months ago
Share
Print
Comments
MySQL introduced cursor in its release 5. You create a cursor to define a set of rows from one or more table that you want to access row-by-row sequentially. If your need is really to access the rows one at a time then use cursor. But a lot of data processing is actually set processing, and set processing is what relational database is best for.
This article compares cursor approach and set approach using various examples.
Read more at: packtpub.com
