CellProfiler-Analyst icon indicating copy to clipboard operation
CellProfiler-Analyst copied to clipboard

Published 20 hours ago • verified publisher icon CellProfiler

Autocomplete for filter crashes for large imagesets (> 50000)

Open daviddao opened this issue 9 years ago • 3 comments

Currently we are running queries to get possible labels for MetaData columns when choosing them from a filter. However for very large image sets, this causes CPA to freeze when creating a new filter because the SQL query takes too long. The gist of the matter can be found here: https://github.com/CellProfiler/CellProfiler-Analyst/blob/master/cpa/columnfilter.py#L94 .

@jhung0 suggested to remove the autocomplete functionality completely. screen shot 2016-01-26 at 5 27 56 pm

daviddao avatar Jan 26 '16 22:01 daviddao

Seems reasonable :+1:

braymp avatar Jan 27 '16 00:01 braymp

If the columns are indexed, then the queries might be fast enough. Perhaps then you could query which columns are indexed and only auto-complete those.

dlogan avatar Jan 27 '16 02:01 dlogan

I uncommented autocomplete (see 5dcb63a) currently but will leave the issue open to see if I can speed it up

daviddao avatar Jan 31 '16 00:01 daviddao