[prev in list] [next in list] [prev in thread] [next in thread] 

List:       syslog-ng
Subject:    Re: [syslog-ng] abandon libdbi and write a new sql driver?
From:       Matthew Hall <mhall () mhcomputing ! net>
Date:       2011-01-24 17:10:51
Message-ID: 20110124171051.GA14382 () mhcomputing ! net
[Download RAW message or body]

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.

> -- 
> Bazsi

Matthew.
______________________________________________________________________________
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

[prev in list] [next in list] [prev in thread] [next in thread]