#Laravel #Database Tip: On v9.18 you can get notified when the application spends too much time querying the database during a single request. Add `whenQueryingForLongerThan` closure in the boot method of `AppServiceProvider`. 🔗https://t.co/KqffBUc8Lx #Laravel #Database #PHP

🚀If performance is the #1 priority in your project you might want to disable lazy loading completely. Eloquent will throw a huge exception in your face if a relation is not eager-loaded and you try to access it. Just use this snippet:

🌶️ #Laravel Tip: There are multiple ways to return the Latest record of relation in Eloquent. However, one method will be more efficient than another. I'm sharing two ways to retrieve the `LatestLogin` of a User model. Check it out 🤯 #PHP #100Devs

🔥 #Laravel Tip: DB queries that need to examine string columns will always be slower than queries which only need to examine integer columns. Therefore, consider whether you can use integers in place of strings for those columns. It can make a big difference on large data sets.

💡#Laravel #Eloquent Advice: Instead of aggregate functions (count, max, min, avg, sum) on the collection, you can directly call them on the database itself. It is more efficient. #Laravel #Database #PHP

#Laravel #Eloquent Advice: If you are making queries by adding a where condition on a string based column, it is better to add an index to the column. Queries are much faster when querying rows with an index column. #Laravel #Database #PHP

🔥 #Laravel Tip: Eloquent includes methods like ‘has’, to help create simple and easy-to-read queries. However, they don’t always generate efficient SQL, which can lead to poor performance. Here’s an example of how a ‘has’ query can be refactored to make it much faster at scale.

Boost memory and performance by leveraging Eloquent scopes. Skip model hydration by calling getQuery() then retrieve your results. A tip from @victorsfleite.

Performance Tip 💡 Tracking something like page views with MySQL can be quite a performance hit when dealing with high traffic. Redis is much better at this. You can use Redis and a scheduled command to keep MySQL in sync on a fixed interval.