jakob / jakob/Postico

Search performance is poor when a database has hundreds of schemas

Open
#362 4 comments 1 reaction 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

I need to optimise the process of fetching database objects from the server.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by tracing the code that fetches database objects from the server and identify where handling many schemas becomes slow. Compare behavior with a database containing hundreds of schemas; done means the search is measurably faster without omitting database objects.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
databases, performance
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.