Cache Eloquent Query Results to Load Pages Instantly

[@alexeykhachatryan1214]

With DB we have two actions - ADD and GET (INSERT and SELECT) In case if it's GET - get from cache. In case if it's ADD - add in DB, and fire an event to update the cache. You could talk about this method in your video. Great job!

[@stefanbogdanovic590]

Awesome idea! Or just invalidate the cache after inserting new entity. But I think your idea is better :)

[@impulserr]

Great idea so you don't need to care about how long to store, you can set forever and just update ;)

[@eboubaker3722]

You just answered the question I asked in my head after watching the video, this is an effective and brilliant technique.

[@VictorSBFI]

An Observer should do that work.

[@alexeykhachatryan1214]

@@VictorSBFI should or can do that?

[@paulfontaine7819]

In case you want the cache to refresh every day, first call after midnight, just add the day in the cache key string. The key then changes every calender day. The old values will be cleared from the cache based on the provided timeout.

[@robiparvez]

regarding database update issue, you can just add a check, where you can assign the cache value to a variable and add empty check. If empty, query from db else load the cache.

[@Frank-ou2nr]

He was talking about the use-case where your cache does have data inside of it, but in the meantime your database was updated and the (now old) cache data is still stored in the file. Using what you suggest (checking if the cache has value) will not work in this case; the cache is not empty and thus your query will never execute and the old data will still be used by your application.

[@oleoni1437]

@@Frank-ou2nr what you mentioned is correct so one way to avoid that it would be to clear the cache every time the data get updated

[@MrAhmedUA]

@@oleoni1437 yeah with some drivers which support cache tags you can for example if you have a cron that gets data from api daily you can do something like Cache::tags(['live-system'])->flush(); also maybe with laravel Eloquent Model upadating ~ deleting ~ creating events you can flush the cache too

[@howtotech3956]

321 likes and 0 dislikes. thats what called a quality channel.

[@alnahian2003]

This video is sooo interesting that I frequently comeback rewatch it.

[@videomania1635]

your each and every video is great source of learning. Thanks...

[@Shez-dc3fn]

the thing with caching i find is then i have to make sure that the cache is deleted on update or w/e... this can get messy if you have lots of cache for different things.. cache packages help but no package afaik has solved the problem of caching relation and then deleting them if relation data changes..

[@educat693]

I think we can use eloquent model events to clear the related cache. It will be a one time effort for each of the model, after that it will be peaceful life. What is your opinion on that? Please let me know.

[@apairca]

I think it's much better and recommended to use a Carbon instance instead of seconds for cache time to live.

[@doremidon]

Why? Do you can explain?

[@Maniac-007]

@@doremidonreadability

[@alexrusin]

Nice video. What if a query runs not 1 second, but 10 seconds. Every day there will be a user that will have to take it for the team. That person may not be very happy. Any cache warming strategies?

[@PovilasKorop]

Hmm, good point. What about artisan command which runs once per night and refreshes the cache in the background? So no actual user would feel that 10 seconds.

[@devanggandhi3266]

Hello Sir, I need your suggestion. I am mainly working on API. so is it good to use cache in every api to speed up response ? what are the cons of using the cache ? if my data will update after 2 hours then can it handel it means does cache give the updated data also ?

[@muhammadfatur8415]

Very helpfull for me as begineer, thank's sir

[@eid9552]

Thank you for your nice tips. I have a question. What if the database is updated before the cache expires? Is there a way you suggest to get the latest data without loosing the performance?

[@jesteriruka4215]

You can run that query in parallel using crontab and artisan commands.

[@НиколайШироков-т7л]

Thank you for your effort!

[@RpExclusive]

may i know what is the browser extensions you used ?

[@WireDroid]

Laravel debugbar

[@ChangeYourLifeForever]

THANK YOU GODFATHER

[@ilmammourtada4538]

Thank you for the video. May I ask what is that console you are using to show the query?

[@PovilasKorop]

Laravel Debugbar, if that's what you meant by "console".

[@santysasa12]

Awesome tip! Thanks a lot

[@ihtishamahmad65]

Where does this cache save? in Browser or our Laravel Application?

[@lifestyleblog6318]

Did you used any extension for checking the Queries

[@LaravelDaily]

Laravel Debugbar

[@Lightnings123]

is it possible to cache on a resource::collection with pagination?

[@oscarfelipeporras9973]

amazing as always

[@namazbekbekarysuly9112]

It is great video. Let's say one applications needs to cache queries in multiple places. How can we regularly trigger caching in all places at particular time. Should we make a cron job that runs some command CacheApplicationCommand?

[@Netherlands031]

I think you can indeed make a laravel scheduled task to your custom command, that uses Cache::put to make sure there's always a fresh cache and users never have to hit the db (for some queries), and then run that command as well when something in the db gets updated and you need to refresh the cache

[@lukmanulhakim8841]

Are it's save for used on production sir?

[@amitleuva8739]

can a query be cached using redis?

[@javerleo]

Excellent explanation! Thanks. Does it work with Eloquent models in Livewire components?

[@LaravelDaily]

Yes, same

[@lifestyleblog6318]

can i used file cached in laravel ?

[@MzN...]

Thx

[@tienphungkhac1491]

What is the extension you just using in the browser?

[@LaravelDaily]

composer require barryvdh/laravel-debugbar

[@tienphungkhac1491]

@@LaravelDaily thanks

[@danorex9100]

Thank you for video :)

[@mreduar]

I have a website that updates the database every time the user downloads a document, that is, I keep track of the downloads of that document. When the database is updated, the cache is lost in the whole app only because of that number update. Any suggestion for this situation?

[@PovilasKorop]

You're probably caching the wrong thing, then. Instead of having one cache query for the whole app, maybe you should cache some specific things that wouldn't be re-cached after one number update. Or, maybe, you should be ok with holding the cache for a little more and not refresh it after EVERY download, just maybe once per hour or so.

[@santiagotv6095]

@Laravel Daily what is the extension yo used to view the query, timeline and etc. like 0:20

[@WireDroid]

Laravel debugbar

[@anasbousrateh9537]

Thank you for this amazing video, it's really helpful

[@music-masala-7789]

if we have dynamic user Id and other field is user IP , this cache is usefull or not ?

[@LaravelDaily]

You need to measure it.

[@EugeneChe-81]

Круто) Спасибо)

[@fire23hummer]

Perfectooo :)

[@ricko13]

This is an excelent feature if you know how and when to use it, I did it wrong and I receive an email from my server provider telling me that my VPS reached a high I/O and so a shutdown was required It was triggered cuz I was using the "file" cache driver in Laravel #LessonLearned

[@fahrim2729]

Best sir

[@shuvoahmed5217]

Make a video about laravel horizon with php redis. Its not working on windows

[@kid_rz]

what aboout paginate data?

[@mudzarao]

Same question. Have you tried playing around it? If yes, did you manage to find a solution for it?

[@DanZL1]

Thank you for the great videos you make. Since you are knowledgeable on Laravel, perhaps you can share your perspective on the following. While speaking to a developer about Laravel and converting our WP website to Laravel, their reply was that Laravel is still unstable and has releases every months or so. What's your response to this?

[@PovilasKorop]

I already replied to you, on another video, read the comment here: kzbin.info/www/bejne/qXLNfYV7gtdgb80&lc=UgxfpVnVL60BIdxtnd54AaABAg

[@SKIDKOVOZ]

Hi I am from Ukraine. I have a problem, I make link shortener on laravel - with counter by clicks on short link, and i have a trouble with add link to cashe and counter clicks on it - correctly, may I ask about some lesson from you about this, or maybe paid lessons so that you help me learn how to do what I want? I am not programmer i try make some functions for myself.

[@DBRSAstonMartin]

How would you refresh the cache say that book title was updated in the database?

[@raminjavi161]

You are such a perfect teacher. I love the way you teach; Your lessons are short, real, and useful. Thank you

[@gado_official]

I wonder if using pagination is it method would works or not?

[@khizer3528]

Thanks for the useful information .

[@isaaclovera8975]

How to the cache in LiteSpeed?

[@mohidden]

best of the best laravel tutos.sup of laravel thanks sir.

[@HosamHasanMonir]

Very helpful , Thanks a lot.

[@mukhtorov]

Thanks!!

[@adriannvalera9923]

Hi sir. May I know what database you use?

[@PovilasKorop]

MySQL