How to fetch big amount of records to be printed

Level 122

and that error says.... ?

4k is nothing

Level 1

@Snapey This page isn’t working. is currently unable to handle this request. HTTP ERROR 500.

Level 75

What does your route, model, controller, view code look like? Check network tab as well. What does error log say?

Level 1

@jlrdw i am using simple query which is:

$accounts = Acc_account::with("items")->where('cat', 2)->get(); and I foreach it in a blade but the problem is with items that can be 1000k for each account

Level 74

And what does the 500 error say? 500 is usually a developer mistake.

Level 75

@Tray2 do you mean sometimes the problem is between the keyboard and the chair? Haha 😁

1 like

Level 74

@jlrdw That is exactly what I am saying.

Level 1

@Tray2 i agree that sometimes 500 errors cause this problem but in my case If i limit the query with 500 for example it works fine, hence the problem is all about the number of data i am fetching

Level 74

@Shady Hesham Then you probably run out of memory on the server. I suggest that you either paginate the data, or use ajax to load it increamentally.

Level 1

@Tray2 thank you for your help, Paginate works fine to surface the data but what about printing?

Level 74

@Shady Hesham what do you mean by printing?

DhPandya

Level 12

@shady Try to implement the Laravel Pagination. It is good when you're dealing with a large amount of Data.

Level 75

@DhPandya I agree with pagination for the displaying. As far as printing @shady hesham

Do all need printing or just a subset of the records.
Many companies these days just browses the data needed via a search
If only a smaller subset, you can export to pdf for printing

Just suggestion.

Also most bigger companies uses other software as well. One department for the State of Texas would dump the data to local and via an ODBC connection print employee recall rosters via Microsoft Access. The point is only print what is absolutely necessary to print.

sylar

Level 32

@shady https://laravel.com/docs/10.x/eloquent#chunking-results, you can check "lazy collections" and "cursors"

Level 1

@sylar i have used chunk but i could not print it in blade and here is my code $accounts = Acc_account::where('cat', 2)->chunk(200, function (account) { foreach ($accounts as $account) { // } }); ;

and when I foreach $accounts in blade I get nothing

DhPandya

Level 12

@Shady Hesham You have a syntax mistake in the posted answer. Please try with the below code.

Acc_account::where('cat', 2)->chunk(200, function (Collection $accounts) {
            foreach ($accounts as $account) {
                //iterate your accounts here
             }
        });

https://docs.github.com/en/get-started/writing-on-github/getting-started-with-writing-and-formatting-on-github/basic-writing-and-formatting-syntax

Level 75

@Shady Hesham and please properly format your code, see:

Snapey