I had a fun one in mind, but it may be too heavy of a calculation for the server to handle. I'm trying to find the biggest gap an individual user has ever had between posting, but that requires looking through the entire post table (~14m records), grouping by user, calculating the gaps between each consecutive post, and then returning the maximums. It's been running for about 5 minutes now with no sign of stopping.
Guessing I'm gonna have to cut it off, but it would be fun if I could get it to run... (At least it seems to be responding OK to normal traffic.)
|