Fast Pagination

@Dan Harrin I implemented the trick for fast pagination you outlined (https://filamentphp.com/community/danharrin-fast-table-pagination) but there is one issue. When selecting

All

All

records, it returns an error for trying to multiply

string * int

string * int

.

I changed the function to:

protected function paginateTableQuery(Builder $query): Paginator
    {
        return $query->fastPaginate(($this->getTableRecordsPerPage() == 'all') ? 9999 : $this->getTableRecordsPerPage());
    }

protected function paginateTableQuery(Builder $query): Paginator
    {
        return $query->fastPaginate(($this->getTableRecordsPerPage() == 'all') ? 9999 : $this->getTableRecordsPerPage());
    }

and that avoids the error. I'm not sure if there is a better way around this.

I didn't see a way to comment on the community post so I'm doing it here. Just wanted you to know. Filament is amazing - thank you!

Filament

How to improve table pagination performance by Dan Harrin - Filament

A collection of beautiful full-stack components for Laravel. The perfect starting point for your next app. Using Livewire, Alpine.js and Tailwind CSS.

Filament•3y ago•

6 replies

bwurtz999

Fast Pagination

@Dan Harrin I implemented the trick for fast pagination you outlined (https://filamentphp.com/community/danharrin-fast-table-pagination) but there is one issue. When selecting

All

All

records, it returns an error for trying to multiply

string * int

string * int

.

I changed the function to:

protected function paginateTableQuery(Builder $query): Paginator
    {
        return $query->fastPaginate(($this->getTableRecordsPerPage() == 'all') ? 9999 : $this->getTableRecordsPerPage());
    }

protected function paginateTableQuery(Builder $query): Paginator
    {
        return $query->fastPaginate(($this->getTableRecordsPerPage() == 'all') ? 9999 : $this->getTableRecordsPerPage());
    }

Filament

How to improve table pagination performance by Dan Harrin - Filament

A collection of beautiful full-stack components for Laravel. The perfect starting point for your next app. Using Livewire, Alpine.js and Tailwind CSS.

Fast Pagination

Similar Threads

Fast Pagination

Similar Threads

Similar Threads

Similar Threads