Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add attribute-based indices to the tf_objects table to speed up the search #100

Open
dtitov opened this issue Oct 29, 2019 · 3 comments
Open
Assignees
Milestone

Comments

@dtitov
Copy link
Collaborator

dtitov commented Oct 29, 2019

Is your feature request related to a problem? Please describe.
The most time-consuming part of the search is actually the execution of a search-query. For example,
11 seconds for experiments.content->'technique'->'term_id' ? 'http://purl.obolibrary.org/obo/OBI_0000748' query and no limit on entries.

Describe the solution you'd like
We should consider adding indices on attributes, e.g. CREATE INDEX idx_tech_type ON tf_objects (content->'technique'->'term_id'); or smth like that. The list of the attributes to index can be extracted from the tf_metamodel table.

Describe alternatives you've considered
We may consider putting different object types to different tables, but it implies a huge overhead in terms of the development - not desirable.

Additional context

@dtitov dtitov added this to the Autumn 2019 milestone Oct 29, 2019
@dtitov dtitov self-assigned this Oct 29, 2019
@sveinugu
Copy link
Collaborator

Priority, but after #101

@dtitov dtitov removed the priority label Oct 31, 2019
@dtitov dtitov modified the milestones: Autumn 2019, Winter 2019 Jan 22, 2020
@amgadhanafy
Copy link

dev server trackfind-dev.gtrack.no

@dtitov dtitov assigned amgadhanafy and unassigned dtitov Jan 28, 2020
@dtitov
Copy link
Collaborator Author

dtitov commented Feb 3, 2020

@amgadhanafy, any progress on this?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants