Snort mailing list archives
Re: Problems with base and postgresql
From: Michael Stone <mstone+snort () mathom us>
Date: Tue, 05 Apr 2005 15:54:47 -0400
On Tue, Apr 05, 2005 at 11:51:09AM -0700, Aaron Glenn wrote:
On Apr 4, 2005 7:52 AM, Michael Stone <mstone+snort () mathom us> wrote:I'd suggest not doing this, it'll really hurt if your system ever crashes. Base is really not tuned for postgres right now--if you want decent performance you're better off just running mysql.What, specifically, needs "tuning" ?
For example, there are a lot of instances of count(*) in the code. mysql shortcuts that operation by keeping a counter, but in postgres that triggers a sequential scan of the table--which can take a while for a large table. There are also some spots where queries could be rewritten to be more efficient by throwing in some joins instead of doing multiple queries and other such items. I've been poking at the code to speed things up, but now I'll have to reintegrate with the new release before sending up a patch & I still need to go back and test that mysql still works after the changes. Mike Stone ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ 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:
- Re: Problems with base and postgresql Michael Stone (Apr 04)
- Re: Problems with base and postgresql Alejandro Flores (Apr 04)
- Re: Problems with base and postgresql Michael Stone (Apr 05)
- Re: Problems with base and postgresql Aaron Glenn (Apr 05)
- Re: Problems with base and postgresql Michael Stone (Apr 05)
- Re: Problems with base and postgresql Bamm Visscher (Apr 05)
- Re: Problems with base and postgresql Frank Knobbe (Apr 05)
- Re: Problems with base and postgresql Michael Stone (Apr 05)
- Re: Problems with base and postgresql Alejandro Flores (Apr 04)