OR queries are very slow and blocks the web server

elixir-oslo / trackfind

FAIR genomic tracks search and curation engine

https://trackfind.elixir.no/

MIT License

3 stars 0 forks source link

OR queries are very slow and blocks the web server #119

Open sveinugu opened 4 years ago

sveinugu commented 4 years ago

To Reproduce

Tab 1: Blueprint query: samples.content->'donor_sex' ? 'Female' OR samples.content->'donor_sex' ? 'Male'
Tab 2: Open trackfind web page. Will not open until search is finished

Expected behavior

[ ] OR search should only be twice as slow as a simple search
[ ] Searching should not block the web server

dtitov commented 4 years ago

I believe this one should be split into two issues because these are completely independent problems (it's just that the second one can be reproduced because of the first one).

And the second one, unfortunately, doesn't seem to be solvable with Vaadin. I have noticed this behavior a long time ago and even asked a question at the Vaadin forum, but I haven't got any meaningful response. I have requested more information there today, so we can follow up on this.

dtitov commented 4 years ago

For the first issue, I'll need to profile the database query execution.

dtitov commented 4 years ago

The guy actually responded in the Vaadin forum thread. And I didn’t understand his explanation again 😕 Maybe you could try to retrieve more of useful information from his comment...