ai-cfia / ai-cfia/ailab-db

Correct delay in response to a search in `ailab-db`

オープン
#38 コメント 1 件 リアクション 0 件 担当者 2 名 @k-allagbe が担当を希望しています GitHub で見る
user-visible
主要言語
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 はまだ評価されていません。

新しい issue をメールで受け取る

初心者向けの GitHub issue を短くまとめたダイジェスト。