Re: Completely unscientific snort db performance test

[Dirk Geschke <Dirk_Geschke () genua de>]

Hi Derek,

> With all the recent discussion about "appropriate" databases to use with
> snort, here are some very unscientific results I've come to with some of
> the work I've been doing at work:
>
> http://www.illusionary.com/snort_db.html

which versions of the database did you use? My latest tests 
which compares inserts in a postgres (7.3.2) and mysql (4.0.10-gamma 
and 3.23.53) show no significant differences in speed.
(Up to now I did not compare selects...)

So I guess you are using an older version of postgres?

Even the use of -F with postgres results in less then 10% 
in speed. But this counts only for the newer versions of
postgres...

One more interesting thing is the memory consumption of
mysql. The mysqld seems to grow in memory with each insert
(I have seen it with more than 100MB of memory size)
whereas postmaster keeps permanently small (around 3.5 MB).

Best regards

Dirk 
-- 
+-------------------------------------------------------------+
| Dr. Dirk Geschke            | E-mail: geschke () genua de      |
| Gesellschaft fuer Netzwerk  | Tel.  : +49-(0)-89-991950-131 |
| und Unix Administration mbH | Fax   : +49-(0)-89-991950-999 |
| 85551 Kirchheim / Germany   | Domagkstrasse 7               |
+-------------------------------------------------------------+




-------------------------------------------------------
This SF.net email is sponsored by: SlickEdit Inc. Develop an edge.
The most comprehensive and flexible code editor you can use.
Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial.
www.slickedit.com/sourceforge
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users