I made the relatively small and straightforward change for this last night, but have not committed it. The query for 30 days was taking upwards of 2 minutes through my (admittedly slow) ssh tunnel to one of the Cassandra nodes. I suspect this is because of the way the DayBucketsCount column family is currently modelled. I'm investigating how we can speed this up in bug 1047268.
I made the relatively small and straightforward change for this last night, but have not committed it. The query for 30 days was taking upwards of 2 minutes through my (admittedly slow) ssh tunnel to one of the Cassandra nodes. I suspect this is because of the way the DayBucketsCount column family is currently modelled. I'm investigating how we can speed this up in bug 1047268.