View Revisions: Issue #952
| Summary | 0000952: Data can be skipped due to aggressive purge on some platforms | ||
|---|---|---|---|
| Revision | 2012-12-13 01:46 by chenson | ||
| Description | MySQL uses the max data_id as the next data_id. If rows 5,6,7,8,9,10 are purged and the next data_id was going to be 11, sym_data_gap would have a gap of 11 to 50,000. The next data_id inserted will be 5 because 5-10 have been purged. data_ids 5-10 will never be routed. Maybe the solution is to never purge the last data_id? |
||
| Revision | 2012-12-13 01:34 by chenson | ||
| Description | Some database platforms (mysql) will insert data_ids that are one greater than the last. Bad for combo of purge and data_gap. Never purge the last data_id. |
||