Marksuh search with bingo postgreSQL
- Dominant language
- C++
- Stars
- 406
- Forks
- 134
- Avg merge
- 2d 11h
- Merged PRs (30d)
- 24
Description
**Steps to Reproduce**
1. PostgreSQL 15.4 Bingo 1.9.1.587-g0e3666ae7
2. `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
**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
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.