tag:blogger.com,1999:blog-8839574367290288724.post8407945698538321110..comments2023-12-11T13:13:11.330-08:00Comments on Pavel Stehule's blog: updatable cursor's testPavel Stěhulehttp://www.blogger.com/profile/01996484227228696817noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-8839574367290288724.post-37383565560764923012008-08-29T10:16:00.000-07:002008-08-29T10:16:00.000-07:00The result is consistent with the idea that relati...The result is consistent with the idea that relational databases are better used in a set oriented fashion when possible. Functions extend the domain of applicability of this set-oriented approach (but beware of SQL code inside them).<BR/>Your tests are interesting for two reasons: <BR/>first: we know how much cursors can suck; <BR/>second: cursors are anyway a very good solution if compared with client side code performing the same task, which should be on average at least an order of magnitude slower (I normally use java with an ORM layer and know what it means).<BR/>Thank you for sharing your results.Luca Veronesehttps://www.blogger.com/profile/10889674744901410391noreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-52639083830278724532008-08-29T05:17:00.000-07:002008-08-29T05:17:00.000-07:00fixed, thanksfixed, thanksPavel Stěhulehttps://www.blogger.com/profile/01996484227228696817noreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-82461057760012359862008-08-29T05:04:00.000-07:002008-08-29T05:04:00.000-07:00The function testc3 is missing.The function testc3 is missing.Anonymousnoreply@blogger.com