MYSQL GROUP BY very slow
I had this problem in one of my project. Currently, we have more than 1 million data per user especially for the log file table. This huge data affecting our stats reporting and become slow and take too long to load the stats.
Anywhere, I manage to overcome this issue and just want to share what I found during the optimization. There is trick you can use to optimize your query with GROUP BY statement.
We start with normal query as below. Both query do the same objective. I just want to see if there any performance impact when I use MONTH and YEAR function in WHERE clause compared to BETWEEN … AND … for the DATETIME selection.
(More …)


Hi there would you mind sharing which blog platform you’re working with? I’m planning to start my own blog soon but I’m having a tough time making a decision between BlogEngine/WordPress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I’m looking for something completely unique. P.S My apologies for getting off-topic but I had to ask!