Mert
Mert
No, the app does stop backing up if it fails for an image. That should be changed to continue backing up the other assets.
Closing as this branch is very stale. It's better to make a new PR when this feature is revisited.
Actually, can't we use this for the search box as well? I think this is a sleek way to search for a location. @alextran1502
The search box here uses `geodata_places`, but it should be possible to adapt this to the `exif` table too
Would you be able to add `EXPLAIN ANALYZE` to the start of this query and show the query plan? That would help narrow down the slowest part of the query.
It looks to me like the slowest parts are the filtering for `isVisible` and `updatedAt` and getting distinct rows. The former is a parallel seq scan and the latter adds...
It looks like this query is a lot more complex than it needs to be. It ultimately just returns `id` and `fileCreatedAt`, so not only is the subquery full of...
That's interesting, it was still doing a seq scan for me until I added the index so I'd expect it to make a difference. Overall though I think this is...
I'm not very familiar with how the app sync works, but it might be fetching 5000 IDs (with the query you posted) and querying the server for the assets of...
Also thanks for sharing the query logs! That will be very helpful