On Wed, Dec 27, 2006 at 12:19:53AM +0100, Wim Pouseele wrote: > I have a big event table (almost 3GB) which causes me problems with the > consolidater process. > After some investigating, I found that the query executed in the event > consolidator is taking up to 3min, even when no new events are added. > > Is there a way to optimize this query? I deleted old events of type unknown or another type I made for stuff I didn't care about that were older than 4 hours.
It dramatically improved the response of the server. - Craig -- Craig Small GnuPG:1C1B D893 1418 2AF4 45EE 95CB C76C E5AC 12CA DFA5 http://www.enc.com.au/ MIEE Debian developer csmall at : enc.com.au ieee.org debian.org ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
