just fyi, if you are doing any kind of aggregation of data in sql tables, make sure you have your indices set up properly. it caught me more times than i'd care to admit where i had primary key on id alone and year/month/.. were separate indices for period aggregation and ON DUPLICATE KEY UPDATE were producing unexpected results.