AOSSIE-Org / AOSSIE-Org/PictoPy

BUG: The Case of the Missing Pointer

Abierto
#1,106 2 comentarios 0 reacciones 0 asignados Ver en GitHub
Lenguaje dominante
Python
Estrellas
283
Forks
679
Merge medio
7 d 2 h
PR fusionados (30 d)
3

Descripción

### Is there an existing issue for this?

- [x] I have searched the existing issues

### 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

- [x] I agree to follow this project's Code of Conduct

Guía de contribución

Abrir la guía de contribución

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.