On Fri, Mar 25, 2011 at 9:54 AM, Roland Bouman <[email protected]> wrote: > 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?)
No (I guess), because SPs (can) contain logic between the queries that uses the output of one and provides the input for another query. -- Olaf _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
