ModioAB / caramel

Caramel is a CA Registry Manager
GNU Affero General Public License v3.0
16 stars 5 forks source link

caramel_tool --list appears slow #54

Open Spindel opened 3 years ago

Spindel commented 3 years ago

With some 1500+ CSR requests and some 20 000 certificates per request, the behaviour of caramel_tool --list becomes annoying.

This is probably because it just does "list all CSR, for each CSR fetch all Certs ordered by ...." or similar. When the correct would be "select csr, max(crt.date) group by csr " or similar query.

Reproduction: