Simple pagination

[mattusik]

You are using laravel paginate method in executeQuery, unfortunately under the hood select count(*) as aggregate from tableName is executed all the time. I'm facing huge performance issues because of this in huge tables. Use simplePaginate instead of paginate would solve my problems.

I was thinking about something like this:

public function configure(): void {
    $this->setPerPageAccepted([5, 10])
         ->setPerPage(5)
      👉 ->setPaginationMode('simple') 👈
         ->setPrimaryKey('user_login_histories.id')
         ->setSearchLazy();
}

I know that simplePaginate will support only prev & next links, but that is completely ok.

[rappasoft]

Added for next release: 8eacdfb

[mattusik]

You are awesome!
Works perfectly now, even for tables with more than 25 mil records.

Thank you so much 😇