Don’t forget about indexes. When you’re using such query as “order by DATE(created_at)” then you need to create a new index exactly for DATE() result because common index for created_at column wouldn’t work.
@@LaravelDaily woww, thanks for the quick reply. No, if its your preference then its absolutely okay. I just said because, most of the time I watch your videos in mobile on the way back home from work at night and my usual mode of transport is Bus. Because of that I have to play the video on full brightness for better visiblity of your IDE and switching apps in your system with white background at full brightness hurts a bit on the long travel and i have to keep adjusting brightness thoughout the video. So just thought, it would be better if all your windows have uniform theme. But I completely respect your preference. And I Love your work. Nice, clean and understanable explanations throughout all your vids. Keep up the great work.🥰
Hi! I have one eloquent problem can you please help me. Let's suppose we have many loans and every loan has many contributors (agency employees). And every contributor can contribute in many loans. Loan--- manyToMany (contributor pivot) ---- Employees--- belongsTo ----User. I want to fetch loans list and eagerLoad only first contributor.
Hello Povilas, Can I ask a question? I have one controller method that is called from two views. Inside the controller method, I want to redirect the user back to different urls depending on from which view the request came from... Is it possible to do this without turning the single controller method to two controllers methods?
I wrote that there may be problem with optimization if the `likes` table is very large, but for some reason my comment is deleted, maybe youtube found some think) In general, optimization is a separate kind of craft.
Hi Povillas. I've got a question. I can see that in your debugbar the memory shown is 5mb. But in my application it shows 17-19mb always no matter how well I optimise it. Btw I'm using Laravel 7. Do you know what could be the reason?
Hi, I have a small question. Is there any way to include featured student into regular student list ?It supposed to be I have a user table, and featured payment table where has user_id column. normal collection I can able to foreach and display users. But If some of the user/student make some payment to list at the top. what to do then in a query ? . I can make separate query and then merge them into collection. But I want in the normal collection. Is there any solution ??
@@LaravelDaily thank you so much for the reply :) . great its working. But its orderBy desc, can it possible in random order and limit 2 or 5 ? thank you again.