Fixed the slow gallery loading (3-6 seconds) on Photo AI now with SQLite and now it's instant

All the SQLite optimizations didn't help much but

Then I came up with a much easier fix

In the SQLite put epoch>last 30 days (timestamp photo taken) first, so it goes from 9 million… pic.twitter.com/Wek1gFNjQ4

— @levelsio (@levelsio) 24 mai 2024

Fixed the slow gallery loading (3-6 seconds) on Photo AI now with SQLite and now it's instant All the SQLite optimizations didn't help much but Then I came up with a much easier fix In the SQLite put epoch>last 30 days (timestamp photo taken) first, so it goes from 9 million

→ View original post on X — @levelsio