[syslog-ng] abandon libdbi and write a new sql driver?

[Evan Rempel]

ODBC allows for prepared statements and is supported on all major databases.
________________________________________
From: syslog-ng-bounces at lists.balabit.hu [syslog-ng-bounces at lists.balabit.hu] On Behalf Of Balazs Scheidler [bazsi at balabit.hu]
Sent: Saturday, February 05, 2011 5:30 AM
To: Syslog-ng users' and developers' mailing list
Subject: Re: [syslog-ng] abandon libdbi and write a new sql driver?

On Mon, 2011-01-24 at 09:10 -0800, Matthew Hall wrote:
> On Mon, Jan 24, 2011 at 12:12:37PM +0100, Balazs Scheidler wrote:
> > But I don't see anything against libdbi per-se, within syslog-ng a
> > similar API would be needed to cover all database APIs, so why reinvent
> > the wheel?
>
> Not having prepared statements means every insert requires a parse.
>
> That cuts the performance of transactional DBs a lot.
>
> Particularly Oracle suffers from this because generating too many statements overflows its memory pools.

I see, good to know. Thanks for the information.

--
Bazsi


______________________________________________________________________________
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