Best practice fetching records. (pagination)

Hi,

I wonder what is best practice when pulling records from db with ajax:

pull all of them and switch pages with vue, OR pull one page, and refresh when searching/filtering?

I guess it depends on table size, but lets say theres 1000 records.

Thanks!

Level 33

Pull them for example 10 by 10. So return Message::latest()->paginate(10); in your controller.

Then in vue you can get the first 10 like this:

second like this:

and so on. There lots of vue.js pagination components that are very useful. For example: http://hootlex.github.io/vuejs-paginator/

Super easy.

1 like

Level 1

I've copied the example from git and I still get this error:

[Vue warn]: Error in created hook: 
(found in <VPaginator>)

Please or to participate in this conversation.