Hi Stewart, all, On Fri, Mar 25, 2011 at 7:29 AM, Stewart Smith <[email protected]> wrote: > The big use case is decreasing the time row locks are held. Mind > you... if this is the last thing left in optimizing your database server > your name probably either rhymes with "Domas" or "Callaghan".
I'm wondering - is it really necessary to have stored procedures for that? Wouldn't batch-execution already do that for you? I mean, the main mechanism for reducing the time the locks are held seems to be the fact that all statements are executed consecutively without roundtripping. If the SP is just a container in this case, then it seems you could do exactly the same with a protocol that accepts a batch (doesn't the drizzle client lib already support that?) > > -- > Stewart Smith > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- Roland Bouman blog: http://rpbouman.blogspot.com/ twitter: @rolandbouman Author of "Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL", http://tinyurl.com/lvxa88 (Wiley, ISBN: 978-0-470-48432-6) Author of "Pentaho Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration", http://tinyurl.com/33r7a8m (Wiley, ISBN: 978-0-470-63517-9) _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
