You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Right now go-buffalo does not support counting with a limit, this causes that in paginated queries for tables with millions of items, no matter how small amount of items we query per page, the time to execute the query will be directly proportional to the amount of items within the table, and in some extremes, we can see paginated queries take just milliseconds to query the items while taking minutes to query the count.
I propose to have a way to either configure the Paginator model to include a property such as MaxPageCount that is used to limit the amount of pages we count while paginating, as most user facing cases, users will never paginate beyond i.e., 99 pages.
The text was updated successfully, but these errors were encountered:
sio4
added
proposal
A suggestion for a change, feature, enhancement, etc
s: triage
Some tests need to be run to confirm the issue
labels
Sep 20, 2022
It seems like this is a duplication of #394, which is on the backlog. I am going to close this issue, please check the linked issue for future updates.
sio4
added
s: duplicate
This issue or pull request already exists
and removed
proposal
A suggestion for a change, feature, enhancement, etc
s: triage
Some tests need to be run to confirm the issue
labels
Sep 24, 2022
pop/finders.go
Line 350 in 5a8f51c
Right now go-buffalo does not support counting with a limit, this causes that in paginated queries for tables with millions of items, no matter how small amount of items we query per page, the time to execute the query will be directly proportional to the amount of items within the table, and in some extremes, we can see paginated queries take just milliseconds to query the items while taking minutes to query the count.
I propose to have a way to either configure the Paginator model to include a property such as MaxPageCount that is used to limit the amount of pages we count while paginating, as most user facing cases, users will never paginate beyond i.e., 99 pages.
The text was updated successfully, but these errors were encountered: