Re: AW: BASE performance

[James Riden <j.riden () massey ac nz>]

"Lieker Heinrich" <hlieker () dohle com> writes:

> Hello!
>
> I have a similar problem.  I'm using BASE with a postgresql
> server. When I refresh the start page, BASE needs lots of seconds to
> load. I have many alarms added to the database per minute.  Do you
> have any ideas, what I should check oder optimize?
>
> Thank you!

> From base.conf - might want to tweak these two options. I have a cron
job which triggers the auto-update and you can choose to manually
trigger it via the web interface if you wish.

You may or may not want referential integrity, depending on whether
the inserts or deletes are your biggest problem.

I did see a web page on optimising ACID or BASE, but I can't seem to
find the reference any more.

cheers,
 Jamie

/* Use referential integrity
 *   1  : use
 *   0  : ignore (not installed)
 *
 * Note: Only PostgreSQL and MS-SQL Server databases support
 *       referential integrity.  Use the associated
 *       create_acid_tbls_?_extra.sql script to add this
 *       functionality to the database.
 *
 *       Referential integrity will greatly improve the
 *       speed of record deletion, but also slow record
 *       insertion.
 */
$use_referential_integrity = 0;

<snip>

/* Event cache Auto-update
 *
 *  Should the event cache be verified and updated on every
 *  page log?  Otherwise, the cache will have to be explicitly
 *  updated from the 'cache and status' page.
 *
 *  Note: enabling this option could substantially slow down
 *  the page loading time when there are many uncached alerts.
 *  However, this is only a one-time penalty.
 *
 *   1 : yes
 *   0 : no
 */
$event_cache_auto_update = 0;


-- 
James Riden / j.riden () massey ac nz / Systems Security Engineer
Information Technology Services, Massey University, NZ.
GPG public key available at: http://www.massey.ac.nz/~jriden/




-------------------------------------------------------
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