OR queries are very slow and blocks the web server

[sveinugu]

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]

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]

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

[dtitov]

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...