On Tue, Jul 10, 2001 at 04:04:43PM +0200, Hannu Krosing wrote:
> Sergio Bruder wrote:
> > 
> > If you have time, take a quick look at
> > 
> > http://acidlab.sourceforge.net/perf/acid_perf.html
> > 
> > PostgreSQL has serious scalability problems with snort + acid. Any
> > advices?
> 
> Usually porting from MySQL to PostgreSQL needs some rewrite of 
> queries and process logic if good performance is required.

ACID is using ADODB SQL interface, thus using the same queries for
MySQL and PostgreSQL.

> 
> > (Now I'm using MySQL with my SNORT/ACID setup, but I'm willing to
> > change to PostgreSQL if more tests are needed)
> 
> Are these tests run using BSDDB backend (for transaction support) or 
> the old/fast MySQL storage ?

Dunno (These tests arent executed by me), but probably using the
old transaction-less format of MySQL.

Sergio Bruder

-- 
Coordenação de Desenvolvimento - Projetos Especiais, Conectiva
http://www.conectiva.com.br, http://sergio.bruder.net, http://pontobr.org
-----------------------------------------------------------------------------
pub  1024D/0C7D9F49 2000-05-26 Sergio Devojno Bruder <[EMAIL PROTECTED]>
     Key fingerprint = 983F DBDF FB53 FE55 87DF  71CA 6B01 5E44 0C7D 9F49
sub  1024g/138DF93D 2000-05-26

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to