tag:blogger.com,1999:blog-4622775563416752930.post190692183671004730..comments2022-09-01T20:53:27.194+01:00Comments on Mark's stream of verbiage: Streaming data from MySQLMark Robsonhttp://www.blogger.com/profile/15864507044869250062noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4622775563416752930.post-77965322276151611332010-05-01T15:04:10.988+01:002010-05-01T15:04:10.988+01:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4622775563416752930.post-10146661678171963472010-04-25T23:34:49.527+01:002010-04-25T23:34:49.527+01:00Server side cursors in stored procedures are kinda...Server side cursors in stored procedures are kinda faked anyways... You can simulate almost exactly identical functionality as the stored proc cursor by selecting into a temporary table and then using the handler statements to retrieve the values one by one.Antonyhttps://www.blogger.com/profile/13094362409916524291noreply@blogger.comtag:blogger.com,1999:blog-4622775563416752930.post-42054719752979434652010-04-25T17:50:09.441+01:002010-04-25T17:50:09.441+01:00"The handler interface does not have to provi..."The handler interface does not have to provide a consistent look of the data (for example, dirty reads are allowed), so the storage engine can use optimizations that SELECT does not normally allow. "<br /><br />I think there is a limited use case for Handler, if a person is using Innodb.Robhttps://www.blogger.com/profile/13656862909374634867noreply@blogger.com