Snort mailing list archives
Re: Deleting messages in ACID (wh~~~~
From: Phil Wood <cpw () lanl gov>
Date: Fri, 4 Jan 2002 09:54:05 -0700
On Fri, Jan 04, 2002 at 10:06:52AM -0600, Daedalus wrote:
About how long should it take to delete ~1000 alerts from a Postgresql database using ACID?
It takes me about 129 seconds to delete 8000 alerts in MYSQL. I only had 28244 alerts to start. This was on a PII 300Mhz. My acid version is: ACID v0.9.6b20, snort is 1.8.3(88)
When I try this I get different results, none of them satisfactory. Most often the browser will sit for a few hours then return the top of an ACID page including the message about how many alerts where added to the cache, but blank after that. The DB has about 150,000 alerts in it. (I'm still working on thining out my rule sets ;-)) P2 500Mhz RH 7.2 Postgresql the came with RH 7.2 latest ACID and required stuff Thanks for any insight, -Bill _______________________________________________ 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
-- Phil Wood, cpw () lanl gov _______________________________________________ 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
Current thread:
- Deleting messages in ACID (wh~~~~ Daedalus (Jan 04)
- Re: Deleting messages in ACID (wh~~~~ Phil Wood (Jan 04)