Skip to content

Image viewer DB performance

Jump to bottom
Aaron W Morris edited this page Dec 3, 2022 · 9 revisions

indi-allsky already makes extensive use of database indexes for peformance, but even those sometimes have limits.

The following indexes will turbo charge your image viewer experience!

sqlite3 /var/lib/indi-allsky/indi-allsky.sqlite 'CREATE INDEX idx_image_createDate_YmdH on image (CAST(STRFTIME("%Y", "createDate") AS INTEGER), CAST(STRFTIME("%m", "createDate") AS INTEGER), CAST(STRFTIME("%d", "createDate") AS INTEGER), CAST(STRFTIME("%H", "createDate") AS INTEGER));'


sqlite3 /var/lib/indi-allsky/indi-allsky.sqlite 'CREATE INDEX idx_video_dayDate_Ym on video (CAST(STRFTIME("%Y", "dayDate") AS INTEGER), CAST(STRFTIME("%m", "dayDate") AS INTEGER));'
Clone this wiki locally