Rebecca Law 4adab1afeb
First draft to purge high volume data on an hourly basis. ...
This makes the assumption that we do not need NotificationHistory, we will need to ensure that for HighVolumeServices we do not recalculate the stats tables, either in the reporting_tasks nor in the commands.
The strategy to migrate to using this code is still up for design.
We will need to consider:
- how to purge the data, safely, efficiently.
- ensure we get the counts right for the stats table, the ft_notification_status table is particularly tricky, because as a notification moves from created -> sending -> delivered the row counts change for each status type. One idea is that we only write the `delivered`, `temporary-failure` and `permanent-failure` status into the table.
This is not production ready but just a draft to get the conversation going.
I also have an idea to stop returning "todays" notification data for HighVolumeServices on the dashboards/usages (except platform_admin) until this code is ready.
2020-03-20 09:34:07 +00:00
2020-01-24 13:18:37 +00:00
2019-06-26 19:03:15 +01:00
2019-06-26 19:03:15 +01:00
2019-06-26 19:03:15 +01:00
2019-04-09 14:33:38 +01:00
2019-04-09 14:33:38 +01:00
2019-04-09 14:33:38 +01:00
2019-06-28 11:22:12 +01:00
2019-06-28 11:22:12 +01:00
2018-08-02 15:55:45 +01:00
2018-08-10 09:09:18 +01:00
2018-08-16 17:10:02 +01:00
2018-08-23 14:43:41 +01:00
2018-08-23 15:04:44 +01:00
2018-08-24 16:09:17 +01:00
2018-08-28 16:22:42 +01:00
2018-08-28 16:56:42 +01:00
2018-08-28 17:24:14 +01:00
2018-08-29 12:46:21 +01:00
2018-08-30 16:36:35 +01:00
2018-08-31 15:56:25 +01:00
2018-09-04 11:10:46 +01:00
2018-09-04 16:55:22 +01:00
2018-09-14 13:58:50 +01:00
2018-09-18 15:22:08 +01:00
2018-09-18 17:41:25 +01:00
2018-09-19 16:32:58 +01:00
2018-09-25 15:10:16 +01:00
2018-09-27 15:20:28 +01:00
2018-09-27 15:20:28 +01:00
2018-09-27 15:20:28 +01:00
2018-09-28 10:25:44 +01:00
2018-09-28 13:52:10 +01:00
2018-09-28 16:19:49 +01:00
2018-10-12 10:36:41 +01:00
2018-10-15 10:37:34 +01:00
2018-10-16 17:30:35 +01:00
2018-10-25 11:19:36 +01:00
2018-10-25 13:27:44 +01:00
2018-10-26 10:33:11 +01:00
2018-10-26 17:50:31 +01:00
2018-11-05 10:03:47 +00:00
2018-11-15 14:44:38 +00:00
2018-11-28 14:38:59 +00:00
2018-12-12 12:14:49 +00:00
2018-12-14 10:58:07 +00:00
2018-12-14 18:12:26 +00:00
2019-01-11 14:44:23 +00:00
2019-01-15 16:55:56 +00:00
2019-01-17 17:06:35 +00:00
2019-01-25 15:03:01 +00:00
2019-02-01 12:57:38 +00:00
2019-02-01 15:04:27 +00:00
2019-02-01 15:11:51 +00:00
2019-02-05 15:00:53 +00:00
2019-02-07 14:28:09 +00:00
2019-02-12 12:15:38 +00:00
2019-02-13 15:40:08 +00:00
2019-02-14 14:27:59 +00:00
2019-02-15 10:09:44 +00:00
2019-02-15 14:35:34 +00:00
2019-02-15 14:44:33 +00:00
2019-02-19 10:23:40 +00:00
2019-06-28 11:22:12 +01:00
2019-02-27 11:50:36 +00:00
2019-03-01 15:21:49 +00:00
2019-03-08 15:03:00 +00:00
2019-03-11 11:43:16 +00:00
2019-03-22 09:30:39 +00:00
2019-03-22 10:49:45 +00:00
2019-03-25 13:28:31 +00:00
2019-03-25 13:30:54 +00:00
2019-03-25 17:31:52 +00:00
2019-04-05 15:40:20 +01:00
2019-04-09 14:33:38 +01:00
2019-04-15 16:14:41 +01:00
2019-04-17 13:39:49 +01:00
2019-05-13 13:05:34 +01:00
2019-05-13 14:45:01 +01:00
2019-05-16 14:36:17 +01:00
2019-05-17 10:33:05 +01:00
2019-05-21 16:08:18 +01:00
2019-06-28 11:22:12 +01:00
2019-06-04 15:30:27 +01:00
2019-06-18 10:41:22 +01:00
2019-06-26 18:36:03 +01:00
2019-07-09 11:57:13 +01:00
2019-07-19 15:13:24 +01:00
2019-07-25 16:03:08 +01:00
2019-08-09 12:41:19 +01:00
2019-08-12 16:03:01 +01:00
2019-08-14 11:01:22 +01:00
2019-08-15 15:17:53 +01:00
2019-08-28 15:24:30 +01:00
2019-09-25 16:33:53 +01:00
2019-10-08 14:02:43 +01:00
2019-11-05 15:01:55 +00:00
2019-11-06 13:54:16 +00:00
2019-12-12 14:11:54 +00:00
2019-12-20 16:17:27 +00:00
2019-12-27 11:21:26 +00:00
2020-01-30 17:28:23 +00:00
2020-01-31 10:59:54 +00:00
2020-02-13 12:42:53 +00:00
2020-03-09 15:42:07 +00:00
2020-03-11 15:31:53 +00:00
2020-03-13 12:11:16 +00:00
2020-03-20 09:34:07 +00:00
4adab1afeb