epam / epam/Indigo

Marksuh search with bingo postgreSQL

Open
#1,902 2 comments 0 reactions 0 assignees View on GitHub
Priority: High Severity: High User`s Feedback
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.