biigle / largo

:m: BIIGLE module to review image annotations in a regular grid
GNU General Public License v3.0
0 stars 1 forks source link

Chunking required in StoreLargoSession #111

Open mzur opened 9 months ago

mzur commented 9 months ago

The StoreLargoSession request validates if all image annotations and video annotations belong to the specified volume. There was a request that tried to store more than 65535 annotations, which is the parameter limit of the SQL query, so the query failed. We need to chunk the annotation array and perform multiple queries if the number of annotations gets too large (e.g. 65000).

mzur commented 7 months ago

There are also similar queries (for images and videos) in the project controller.