Hey Sven,
On Fri, Apr 28, 2006 at 02:31:43PM +0200, Sven Anderson wrote:
> it seems to be known, that a default MySQL performs a lot better than a
> default PostgreSQL. One difference is, that PostgreSQL is doing an COMMIT
Not to open a possible flame, but i fully agree with this view. However, we
massively deal with network objects (IP and MAC addresses, network subnets)
which are handled properly only by PostgreSQL. Do you see chances that this
can re-open the challenge on this scenario ?
> Paolo, are you using transactions in the PostgreSQL plugin, to COMMIT all
> UPDATES in one bunch? I couldn't clearly see it in the source code.
Sure! Macro-transactions are in use since ages (both in PostgreSQL and SQLite
plugins -- "grep COMMIT src/*"). The approach of the very first versions of
the plugin was to use micro-transactions. But intuitively it was performing
horrendly compared to the actual approach.
Cheers,
Paolo
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
