purldb icon indicating copy to clipboard operation
purldb copied to clipboard

Published 20 hours ago • verified publisher icon nexB

Performance issue with api/collect endpoint

Open sschuberth opened this issue 6 months ago • 2 comments

Cross-posting from here for visibility, querying https://public.purldb.io/api/collect/?purl=pkg:npm/[email protected] takes close to 30s (for getting a 4k JSON response):

$ time curl https://public.purldb.io/api/collect/?purl=pkg:npm/[email protected]
...
real    0m27.074s
user    0m0.020s
sys     0m0.018s

which seems to be extremely slow. For our use-case to speed up ORT scans by retrieving existing scan results for packages, this is problematic.

Is this kind of performance expected? Is there any way to speed things up?

sschuberth avatar May 08 '25 12:05 sschuberth

@sschuberth Thanks for the report and sorry for the late reply. Let me make sure we look into it.

pombredanne avatar Jul 17 '25 12:07 pombredanne

Any update here @pombredanne? We were talking about this in the OCCTET WP3 meeting with @heurtematte.

sschuberth avatar Sep 25 '25 12:09 sschuberth