Is there an existing issue for this?
What happened?
Where : main/backend/app/database/images.py
What happened ? : db_get_images_by_folder_ids queries by folder_id.
What should be : CREATE INDEX idx_images_folder_id ON images(folder_id);
Why?: Without an index, viewing a specific folder requires scanning the entire images table.
Record
Is there an existing issue for this?
What happened?
Where :
main/backend/app/database/images.pyWhat happened ? :
db_get_images_by_folder_ids queries byfolder_id.What should be : CREATE INDEX
idx_images_folder_idON images(folder_id);Why?: Without an index, viewing a specific folder requires scanning the entire images table.
Record