#relationship (1) #vps (5) #ssh (1) #command (1) #tricky (10) #cpanel (1) #docker (5) #eloquent (2) #excel (1) #testing (1) #en (22) #cron (1) #linux (8) #livewire (3) #laravel (13) #server (1) #session (1) #select2 (2) #devops (4) #git (1)

11-01-2023

whereIn - integer TIP

Laravel Tip: Instead of using the ๐˜„๐—ต๐—ฒ๐—ฟ๐—ฒ๐—œ๐—ป() method to load a large range of data when the targeted value is an integer, use ๐˜„๐—ต๐—ฒ๐—ฟ๐—ฒ๐—œ๐—ป๐˜๐—ฒ๐—ด๐—ฒ๐—ฟ๐—œ๐—ป๐—ฅ๐—ฎ๐˜„() which is faster than ๐˜„๐—ต๐—ฒ๐—ฟ๐—ฒ๐—œ๐—ป().

Benchmark::measure([ 
fn() => User::whereIn('id', range(1,500))->get(), 
fn() => User::whereIntegerInRaw('id', range(1,500))->get() 
], 3) 

Run 3 times. 
Result: 
5.80 0.86 
4.30 1.69 
3.08 0.92
More posts
#relationship (1) #vps (5) #ssh (1) #command (1) #tricky (10) #cpanel (1) #docker (5) #eloquent (2) #excel (1) #testing (1) #en (22) #cron (1) #linux (8) #livewire (3) #laravel (13) #server (1) #session (1) #select2 (2) #devops (4) #git (1)
DLNA service on your server

This is how you setup DLNA service to your server!

#en #livewire #server
Increase swap size

Want to increase swap size on linux?

#en #linux
Login via SSH key only

Want to connect to server via SSH key only? Let's do it!

#en #linux
Twitter GitHub LinkedIn

© 2024 PappZ. All rights reserved.