4 ms·
Can this be used to enforce a temporal limit on data? That is, if the check is for time to be within 24 hours of now will it purge older than 24 hours data as t
by RobotCaleb 12y ago
Can this be used to enforce a temporal limit on data? That is, if the check is for time to be within 24 hours of now will it purge older than 24 hours data as time progresses? My gut tells me no, but my gut is often wrong when it comes to databases.
- keithgabryelski 12y agoif I understand you correctly, this type of thing is implemented by partitioning by hour in a day and then having a janitor process drop tables that are older than 24 hours.
- morgo 12y agoALTER TABLE .. TRUNCATE PARTITION should be much faster than deleting as well. At least it is in MySQL.
- batbomb 12y agoyou can in oracle, and I believe db2. It's called range partitioning.