syslog-ng-users February 2011 archive
Main Archive Page > Month Archives  > syslog-ng-users archives
syslog-ng-users: Re: [syslog-ng] abandon libdbi and write a new

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

From: Balazs Scheidler <bazsi_at_nospam>
Date: Tue Feb 22 2011 - 14:25:42 GMT
To: Syslog-ng users' and developers' mailing list <syslog-ng@lists.balabit.hu>

Hi,

The problem with ODBC is that it is a _big_ package, with a separate
daemon running, and last I've checked database drivers are not
necessarily free. (this applies to the unixodbc package).

On Sat, 2011-02-05 at 10:08 -0800, Evan Rempel wrote:
> ODBC allows for prepared statements and is supported on all major databases.
> ________________________________________
> From: syslog-ng-bounces@lists.balabit.hu [syslog-ng-bounces@lists.balabit.hu] On Behalf Of Balazs Scheidler [bazsi@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
>
> ______________________________________________________________________________
> 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
>
>

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