[neutron] When num of port mappings is substantial, the response time of List API so slow

Hello，

I have a Victoria cluster with 1 controller node(also have nova-compute service) and two compute node. ALL node boasts 128 CPU cores and 512GB of memory.

I established 1500 port mappings for a single floating IP A. At this point, the response time for the "List Floating IP Port Forwardings" API[1] becomes remarkably slow, approaching a duration of 9 minutes.

Does anyone comprehend the cause of this phenomenon or how should I investigate it?

I am immensely grateful for any assistance provided.

Best regards, Han Guangyu

[1] https://docs.openstack.org/api-ref/network/v2/index.html#list-floating-ip-po...