Files
Art-gallery/db/migrate-perf-indexes.sql
Danila Khodjaef 99b8559607 Speed up timeline load with portrait thumbs, bootstrap API, and caching.
Add catalog bootstrap endpoint, portrait thumbnail pipeline, lazy queued timeline images, gzip compression, and 3D texture throttling with code-split VirtualGallery.
2026-07-06 14:27:29 +03:00

5 lines
328 B
SQL

-- Query performance for timeline filters and influence lookups
CREATE INDEX IF NOT EXISTS idx_artists_birth_year ON artists(birth_year);
CREATE INDEX IF NOT EXISTS idx_artists_death_year ON artists(death_year);
CREATE INDEX IF NOT EXISTS idx_influence_sources_source_painting ON painting_influence_sources(source_painting_id);