IP vs Date Partition

[Tim Linden]

Hey Guys

I've started to use parititons and am seeing the speed benefits, but I'm unsure if I'm doing it the best way.

I'm tracking data on the last time an IP took an action. Right now to save space it simply updates the last time field and other data each time they do the action again. I'm then dumping any IPs that have been over 30 days.

My partition is currently based on IP address. Which has improved the speed in tracking, but I'm not benefiting from faster drop offs over that 30 days.

I'm hesistent to try partitioning based on date because then it's 30 partitions on each update to find that IP, and if it's been a few days and I update the record to today's date it's gotta move that record which adds more latency.

So your thoughts? Or am I overestimating how long it takes to check each partition or move data between them?

Thanks!

Tim