<html><head></head><body>I agree with Bill and I don't. I hate Gmail, unlike him, but I agree that there is value in retaining *all* the old tickets. I can think of all least two use cases off the top of my head where I'd want to go back to an association report after >90d had passed, and I've encountered one of them within the last year.<br>As an alternate suggestion, I don't see any problem with moving those records out of the mainline UI onto another page and into another database.<br>Like many others here, though, I'm puzzled at how a modern database system could be this badly hobbled (in an apparently-intractable way) by mere millions of tickets.<br><br>-Adam Thompson<br><br><div class="gmail_quote">On July 1, 2019 8:43:07 a.m. CDT, William Herrin <bill@herrin.us> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="ltr"><div dir="ltr"><div dir="ltr"></div><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jun 26, 2019 at 10:51 AM ARIN <<a href="mailto:info@arin.net">info@arin.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Since the launch of ARIN Online, we have been in the practice of<br>
retaining all customer tickets, and this includes ticketed requests for<br>
reports of the following types:<br>
<br>
* Associations reports<br>
* WhoWas reports<br>
* Reassignment reports<br>
* User Reassignment reports<br>
<br>
After eleven years, we have well over a million such report tickets that<br>
we believe should be deleted from our systems in order to improve system<br>
performance, and to improve the customer experience by clearing<br>
unnecessary clutter from report tickets in the ticket history. It is our<br>
intention to move forward with deleting the report tickets of the above<br>
types (and associated reports) that are over 90-days old, and to change<br>
our ticket retention policy so that these types of tickets requesting<br>
reporting will expire and be deleted after 90 days going forward.<br></blockquote><div><br></div><div>Hi Folks,</div><div><br></div><div><div>A million seems like nothing for a modern data system to handle.
I'd rather see ARIN invest in technology improvements that eliminate the
performance problem. It is, for example, usually trivial to extract
large attachments from a database and store them on a filesystem with a
link from the ticket. Storage on the filesystem tends to have little performance penalty for the application as a whole.</div><div><br></div><div>Even if you don't, 90 days is way too short.<br></div><div> </div><div>I'm
not a consumer of these particular reports but in general I find it
convenient to be able to search every interaction I've had. I like
gmail's approach of deleting only the things which are actually and
explicitly trash.</div><div><br></div><div>Regards,</div><div>Bill Herrin</div><div><br></div></div></div></div></div></blockquote></div><br>-- <br>Sent from my Android device with K-9 Mail. Please excuse my brevity.</body></html>