You should verify that you indexes are correct. Try running the same query with "EXPLAIN" in front directly from the MySQL CLI to understand why is taking so long.
Javier Wim Pouseele wrote: > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/jffnms-users -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Javier Szyszlican, Project Leader, JFFNMS [EMAIL PROTECTED] I hope JFFNMS or I were helpful to you, if you can, please donate at http://jffnms.org/donate ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/jffnms-users
