Slow response times with 1300 endpoint entries

[Katzor]

We recently created 1300 SMP Endpoint entries and now have 1,920 entries on https://smp.test.ecosio.com/secure/locale-en_US/menuitem-endpoint_list. Users reported and and I confirmed that calling https://smp.test.ecosio.com/secure/locale-en_US/menuitem-endpoint_list takes now around 30 seconds on each invocation.

[2024-12-18T08:25:37,913] [SMP-SERVER] [INFO ] [RequestTrackerMonitor-1] Successfully executed 'insert' [32] -- com.helger.phoss.smp.backend.mongodb.MongoClientProvider$LoggingCommandListener.commandSucceeded(MongoClientProvider.java:65)
[2024-12-18T08:25:37,909] [SMP-SERVER] [ERROR] [RequestTrackerMonitor-1] Long running request. ID=91195; millisecs=33976; Remote IP=10.2.131.20; URL=http://smp.test.ecosio.com/secure/locale-en_US/menuitem-endpoint_list -- com.helger.commons.log.LogHelper.log(LogHelper.java:492)
[2024-12-18T08:25:35,928] [SMP-SERVER] [INFO ] [RequestTrackerMonitor-1] Successfully executed 'insert' [31] -- com.helger.phoss.smp.backend.mongodb.MongoClientProvider$LoggingCommandListener.commandSucceeded(MongoClientProvider.java:65)
[2024-12-18T08:25:35,924] [SMP-SERVER] [ERROR] [RequestTrackerMonitor-1] Long running request. ID=91195; millisecs=31990; Remote IP=10.2.131.20; URL=http://smp.test.ecosio.com/secure/locale-en_US/menuitem-endpoint_list -- com.helger.commons.log.LogHelper.log(LogHelper.java:492)

cc @mzapletal, @gerdailger

[phax]

This is basically the same as #300

But 30 seconds for 1300 endpoints is extremely slow.
You are using the MongoDB backend, correct?

[phax]

Version 7.2.0 should bring some improvement when it comes to list of service groups and endpoints