Comment 1 for bug 1530866

This is effectively a duplicate of https://bugs.launchpad.net/bileto/+bug/1508186 in the sense that fixing that one would also fix this one. Long story short, I'm not happy with the way published_versions field works on the ticket (too easy to clobber old data with new data during publishing). That's why I switched it to being a field on the comments, so that there'd be an immutable record of what was published and when.

But, as you say, parsing through every comment on every ticket is expensive and requires many API requests. So I'd prefer to make an entirely new db table to contain publishing records and use that to replace the weird rsync thing we're doing now.