[ARIN-consult] ACSP Consultation: Deleting Aged Report Request Tickets

Adam Thompson athompso at athompso.net
Mon Jul 1 10:11:41 EDT 2019

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.
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.
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.

-Adam Thompson

On July 1, 2019 8:43:07 a.m. CDT, William Herrin <bill at herrin.us> wrote:
>On Wed, Jun 26, 2019 at 10:51 AM ARIN <info at arin.net> wrote:
>> Since the launch of ARIN Online, we have been in the practice of
>> retaining all customer tickets, and this includes ticketed requests
>> reports of the following types:
>>      * Associations reports
>>      * WhoWas reports
>>      * Reassignment reports
>>      * User Reassignment reports
>> After eleven years, we have well over a million such report tickets
>> we believe should be deleted from our systems in order to improve
>> performance, and to improve the customer experience by clearing
>> unnecessary clutter from report tickets in the ticket history. It is
>> intention to move forward with deleting the report tickets of the
>> types (and associated reports) that are over 90-days old, and to
>> our ticket retention policy so that these types of tickets requesting
>> reporting will expire and be deleted after 90 days going forward.
>Hi Folks,
>A million seems like nothing for a modern data system to handle. I'd
>see ARIN invest in technology improvements that eliminate the
>problem. It is, for example, usually trivial to extract large
>from a database and store them on a filesystem with a link from the
>Storage on the filesystem tends to have little performance penalty for
>application as a whole.
>Even if you don't, 90 days is way too short.
>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
>approach of deleting only the things which are actually and explicitly
>Bill Herrin
>William Herrin
>bill at herrin.us

Sent from my Android device with K-9 Mail. Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.arin.net/pipermail/arin-consult/attachments/20190701/9788eec2/attachment.html>

More information about the ARIN-consult mailing list