Apigee X: Drupal Monetization: Add an app page and list Apps page is extremely slow

[welylau]

Description

A clear and concise description of what the bug is.
Apigee X: Drupal Monetization: Add an app page and list Apps page is extremely slow

Apigee Info

Please specify if you are using Apigee X, Apigee Edge, or OPDK.
X

Steps to Reproduce

Steps to reproduce the behavior:

1. Login with an account
2. Click on Apps, notice that it can easily take 30 seconds for my apps to load (FYI, I have about 20 apps)
3. Click "Add app", now it takes about another 30 seconds to load all the products in the Add App page (FYI, I have about 35 products)

Screen.Recording.2025-03-19.at.6.23.30.PM.mov

Actual Behavior

What happened after the steps to reproduce.
slow (refer to the top)

Expected Behavior

A clear and concise description of what you expected to happen.
I expect this to load within 3 seconds (for both add app and list app)

Screenshots

If applicable, add screenshots to help explain your problem.
(Attached)

Notes

Add any other context about the problem here.
Already in discussion with @kedarkhaire

Version Info

This can be the version you can see on admin/modules in Drupal or
the output of this command: composer show. Add Drupal core and
other version information if needed.
Drupal core 10.3.0
Apigee 3.0.7
Apigee API Catalog 3.0.6
Apigee Monetization 2.1.2

[kedarkhaire]

Hi @welylau
Thanks for creating this issue.

Earlier from our conversations and checks, adding my understanding here for the slow load.

Currently it is hitting every api-product with the rate plan to check if it is purchased or free & provides filtered list.
So if you are having 20 + Rate Plans then every api product will be checked with every RatePlan, this is causing the issue.

Thanks!

[welylau]

Hi @kedarkhaire
I have 8 rate plans in my org.
Having said that even if there are over 20+ rate plans, the loading time should be improved.

[dracleen]

Hi @kedarkhaire. We are having the same Issue. Since the customer opted for only 1 Apigee instance for 3 Environments we have triple the amount of API Products and Rateplans. Is there no way to cache the information when its loaded the first time? Or to consolidate all the GET Request into one single one? Help would be much appreciated! Thanks!