Correct delay in response to a search in ailab-db

[melanie-fressard]

To address louis-finesse issue #14 Delay in Responses (to a query or search) on version v0.1.0, 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 Developing a Search Function Test Utilizing LLM #9

[rngadam]

the second point is covered by issue #9

your checklist should be a list of task, right now the first point is the objective. if you want to focus, you need to outline the list of steps you need to do to get to that objective.