select * from structures where smiles@('C1C(*)=CC(*)=CC=1 |$;;X_p;;;Q_e;;$|', '')::bingo.sub
Expected behavior
Fast request processing speed close to processing with *(select * from structures where smiles@('C1C(*)=CC(*)=CC=1', '')::bingo.sub)
Actual behavior
Slow query execution. Searching for 10 Markush structures takes about a minute. Searching 10,000 structures with * takes about 30 seconds
Steps to Reproduce
select * from structures where smiles@('C1C(*)=CC(*)=CC=1 |$;;X_p;;;Q_e;;$|', '')::bingo.subExpected behavior Fast request processing speed close to processing with
*(select * from structures where smiles@('C1C(*)=CC(*)=CC=1', '')::bingo.sub)Actual behavior Slow query execution. Searching for 10 Markush structures takes about a minute. Searching 10,000 structures with * takes about 30 seconds
Environment details: x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
Additional context The documentation does not contain an example of a correct query for searching using the Markush structure https://lifescience.opensource.epam.com/bingo/user-manual-oracle.html#queries