sil-ai / aqua-api

API for Augmented Quality Assessment
MIT License
3 stars 0 forks source link

Optimize missing words query #327

Closed woodwardmw closed 7 months ago

woodwardmw commented 7 months ago

The takes the aggregation to dictionary that was in Pandas and puts it into SQL, which gives improved speed.

The longest missing words (e.g. Psalms, with 29 baseline_ids) now takes around 40 seconds instead of 100 seconds when running on my local server. (Both should be a bit quicker on the deployed API).