Hi, 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? (query used in jffnms/engine/consolidate/events.php) Many thanks, Wim -------------------------------------------------------- Wim Pouseele Vlerick Leuven Gent Management School Reep 1, BE-9000 Gent, Belgium Vlamingenstraat 83, BE-3000 Leuven, Belgium Phone +32 9 210 9 8 42 Fax +32 9 210 9 1 42 http://www.vlerick.be mailto:[EMAIL PROTECTED] Disclaimer: http://www.vlerick.be/privacy/email/index.html -------------------------------------------------------- ------------------------------------------------------------------------- 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
