#relationship (1) #vps (5) #ssh (1) #command (1) #tricky (10) #cpanel (1) #docker (5) #eloquent (2) #excel (1) #testing (1) #en (19) #cron (1) #linux (6) #livewire (2) #laravel (13) #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 (19) #cron (1) #linux (6) #livewire (2) #laravel (13) #session (1) #select2 (2) #devops (4) #git (1)
Setting maximum send out email

Do you ever faced a requirement, so that you must not allow to send out emails after a given amount? Come with me!

#en #laravel
PappZ

2 MIN READ

Delete Git branch local/remote

Deleting git branches both locally and remote.

#en #git
PappZ

1 MIN READ

Add Temp URL for files

Adding temporary download URL for your local files.

#en #laravel
PappZ

1 MIN READ

Twitter GitHub LinkedIn

© 2024 PappZ. All rights reserved.