Correct delay in response to a search in `ailab-db`
- 主要言語
- Jupyter Notebook
- スター
- 1
- フォーク
- 0
- PR マージ指標
- 30日以内にマージされた PR はありません
説明
To address louis-finesse issue [#14 Delay in Responses (to a query or search) on version v0.1.0](https://github.com/ai-cfia/louis-finesse/issues/14), we need to improve the search function.
Tasks :
- [ ] Indexing: If necessary and possible, ensure that appropriate indexes are created on columns used in SQL function. Indexes can significantly speed up data retrieval.
- [ ] Query Analysis: Analyze the SQL queries with the help of tools like the SQL Profiler or EXPLAIN ANALYZE.
- [ ] Data Retrieval: Minimize the amount of data retrieved by queries. Use SELECT statements to fetch only necessary columns and rows. Avoid using SELECT * if possible.
- [ ] Limit and Offset: If applicable, use LIMIT and OFFSET to restrict the number of rows returned, especially for paginated results. This can reduce the amount of data transferred and processed.
- [ ] Partitioning: If dealing with large datasets, partition tables to distribute data across multiple filegroups or disks. This can speed up data access.
- [ ] Index Maintenance: Regularly maintain and rebuild indexes to keep them optimized. Fragmented indexes can slow down query performance.
Expected results :
- [ ] Lower the response time to the following range : 0 ms ≤ t ≤ 500 ms
Testing :
- [ ] Use openai to get questions to test on our search - issue #9
コントリビューションガイド
このリポジトリのコントリビューションガイドは索引されていません
評価
この issue はまだ評価されていません。