Potti
1 month ago
210
6
General

Handling over 7k records, groupBy and pagination

Posted 1 month ago by Potti

I have a situation that can't get my head around. In database I have over 7k records. So pagination at server side best thing to do. But I can't do that because I must use groupBy on the data. Official Laravel Docs says "pagination operations that use a groupBy statement cannot be executed efficiently by Laravel." and It's offering a frontend custom pagination.

What is best way to handle this kind of situation. After using groupBy should I just send all 7k to client side and apply custom pagination. Is it right way to do it? Also if I use custom pagination in frontend. Then how can I follow the page links? I mean dynamicly slicing the array and there is no url path =2 or etc... to follow the pages...

Please sign in or create an account to participate in this conversation.