damontecres / StashAppAndroidTV

Android TV App for Stash
GNU Affero General Public License v3.0
74 stars 4 forks source link

Separate loading pages and counting items #255

Closed damontecres closed 3 months ago

damontecres commented 4 months ago

Prior to this PR, whenever a page of items is fetched, it included the total count of items that the filter applied to, but the total count is only needed once.

This meant an extra sql query to count the items on every page fetched. Usually this extra query isn't much, but for large servers, it can add up.

Related to #208 and #254