/api/annotation/search.json interface is too slow

[luo-guoping]

Hello, I would like to ask about the "/api/annotation/search.$format" interface. The execution of this interface is too slow. Is there a better solution for the SQL in the interface? Or have any better suggestions.

[luo-guoping]

After testing, SQL is actually OK, but the interface still wants to be optimized, the response speed is still a bit slow, want to improve, is there any solution?

[geektortoise]

Hello,
As annotations concerns multiple tables and we can use multiple filters, Cytomine generate complex queries.
Did you try to paginate your requests (with max and offset) ?

What are your queries ?