syslog-ng-users April 2011 archive
Main Archive Page > Month Archives  > syslog-ng-users archives
syslog-ng-users: Re: [syslog-ng] [RFC]: afsql improvement plans

Re: [syslog-ng] [RFC]: afsql improvement plans

From: Hendrik Visage <hvjunk_at_nospam>
Date: Fri Apr 01 2011 - 14:35:40 GMT
To: "Syslog-ng users' and developers' mailing list" <syslog-ng@lists.balabit.hu>

On Fri, Apr 1, 2011 at 3:05 PM, Gergely Nagy <algernon@balabit.hu> wrote:

> Prepared statements
> -------------------
>
> We'll use prepared statements wherever possible - I expect this alone
> will result in a measurable performance increase, since the server will
> not have to parse each and every insert - only once, we'll bind
> variables thereafter.

This is also a performance increase for Postgresql/etc. so this should
(IMHO) be an universal method for all the SQL drivers, as it is
expected give a global rather than specific gain.

Postgresql's COPY appears to be equivalent to the MySQL's LOAD, so my
advice will be to keep these two methods in a way to easily
replace/substitute for Postgresql ;)

Hendrik
______________________________________________________________________________
Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng
FAQ: http://www.campin.net/syslog-ng/faq.html