Project

General

Profile

Actions

Bug #14259

closed

product API call with 'enabled=true' slow, causing product page to load slowly

Added by Chris Duryee about 8 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Performance
Target version:
Fixed in Releases:
Found in Releases:

Description

The product listing page takes about 5-7 seconds to load with 10 custom products and 7 RH products enabled.

It looks like the 'enabled=true' flag when calling the products API has something to do with this. For example:

# time curl -sk 'https://admin:changeme@localhost/katello/api/products?organization_id=3&page=1&paged=true&search=&sort_by=name&sort_order=ASC' > /dev/null

real    0m1.853s
user    0m0.034s
sys     0m0.024s

# time curl -sk 'https://admin:changeme@localhost/katello/api/products?enabled=true&organization_id=3&page=1&paged=true&search=&sort_by=name&sort_order=ASC' > /dev/null

real    0m4.246s
user    0m0.024s
sys     0m0.028s

There is a 'self.enabled' method on the product model that may need investigation.

Actions

Also available in: Atom PDF