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" <>

On Fri, Apr 1, 2011 at 3:05 PM, Gergely Nagy <> 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 ;)

Member info: