[address-policy-wg] Mass deletion of assignments from RIPE Database?

Hi Denis,

> On 17 May 2021, at 15:16, denis walker <ripedenis at gmail.com> wrote:
> 
> ...
> Question to the RIPE NCC...
> Can you select a random week day

I selected yesterday, 17th May.

> and calculate the total number of
> queries where the query string is an IPv4 address.

I found 54M queries for an IPv4 address out of 68M total queries.

> If possible can you
> determine if the query string address is contained within a PA
> assignment object

I found 33M queries where the query string is directly within an IPv4 "ASSIGNED PA" (inetnum) object (ignoring any flags).

> and calculate the percentage of these queries that
> would have returned an assignment object.

Taking the hierarchical query flags into account, 33M queries also returned at least one IPv4 "ASSIGNED PA" inetnum object, so 100%.

> If this recommendation is
> accepted, these queries in future would most likely only return the
> resource allocation object.
> 


These numbers have some uncertainty, as I used the split files generated at 3AM this morning, versus query logs for the whole of yesterday. Lots of inetnum objects were deleted or created during the day.

Regards
Ed Shryane
RIPE NCC