Cytomine-core icon indicating copy to clipboard operation
Cytomine-core copied to clipboard

Published 20 hours ago • verified publisher icon cytomine

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

Open luo-guoping opened this issue 3 years ago • 2 comments

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 avatar Aug 04 '21 03:08 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?

luo-guoping avatar Aug 06 '21 02:08 luo-guoping

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 ?

geektortoise avatar Aug 06 '21 08:08 geektortoise