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

[Adam Thompson]

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
>for
>> 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
>that
>> we believe should be deleted from our systems in order to improve
>system
>> performance, and to improve the customer experience by clearing
>> unnecessary clutter from report tickets in the ticket history. It is
>our
>> intention to move forward with deleting the report tickets of the
>above
>> types (and associated reports) that are over 90-days old, and to
>change
>> 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
>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.
>
>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
>gmail's
>approach of deleting only the things which are actually and explicitly
>trash.
>
>Regards,
>Bill Herrin
>
>
>-- 
>William Herrin
>bill at herrin.us
>https://bill.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>