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...