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.
>
> > (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 ?
I'm not familiar with SNORT/ACID, but I assume that the DB schema and queries are basically all identically for
all the databases.
Well, how such analyzis software can be implemented without views and stored procedures is a mystery to me, but
at least it must do a whole lot of PHP-aerobics.
I'd say as long as the database is used as a stupid data container and not as a relational database
managementsystem, just don't use Postgres. It's not designed to be stupid, so it doesn't work well if used
stupid.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com