On Mon, Apr 20, 2009 at 13:09, <[email protected]> wrote: > is it really any more efficiant to define a stored procedure or prepared > statement through the API than through the exec() call? > > and even if it is, is this something that is done once per startup or > every command? if it's once per startup the complexity cost may not be > worth the small time savings.
I don't have numbers on the overhead bit, there are application notes for MySQL (http://dev.mysql.com/doc/refman/5.1/en/sql-syntax-prepared-statements.html, paragraph 2) that notes that the SQL interface is not as efficient as their binary protocol, but gives no justification. I won't argue whether binary protocols are faster, but agree with the assertion that the gain may not be sufficiently significant in this use case. _______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog http://www.rsyslog.com
