Performance: Missing Database Indexes

[vjpixel]

Medium Performance Issue

Missing database indexes on frequently queried fields.

File: Database migrations
Severity: MEDIUM
Impact: Slow query performance

Issues Found:

1. No index on user_id in objects table
2. No index on created_at for sorting
3. Missing composite indexes

Suggested Fix

Add database indexes:

# In migration file
operations = [
    migrations.RunSQL(
        "CREATE INDEX CONCURRENTLY idx_objects_user_id ON core_object(user_id);",
        reverse_sql="DROP INDEX IF EXISTS idx_objects_user_id;"
    ),
    migrations.RunSQL(
        "CREATE INDEX CONCURRENTLY idx_objects_created_at ON core_object(created_at DESC);",
        reverse_sql="DROP INDEX IF EXISTS idx_objects_created_at;"
    ),
]

[pablodiegoss]

Looking at the timestamped model from django extensions I've noticed that the created and modified fields do not have indexes on them, which is bad since we do a lot of sorting and filtering by these fields, specially on admin pages. We should update and include indexes on these fields, but now with raw queries as suggested, we should probably remove the timestamped model inheritance and create manually the created and modified fields.

Removing the django extensions dependency however might be harder as we need to ensure previous migrations still run correctly.

User IDs we should not interfere as we use the default django user model.

LGTM