Level 74
If you have the record already in the table you should update it instead of removing it and recreating it. Update is one transaction while deleting and recreating needs two.
1 like
Oct 9, 2021
4
Level 1
UPDATE or INSERT statement better for this case?
I have a simple table to store data just for reading. For example, It consists of id, payload, user_id and timestamps.
I am doing sync every day for this table and just renew the data in payload column.
Is it better to use UPDATE or INSERT statement? If I am using INSERT statement means I need to delete the rows and re-insert again. Which may caused the increment ID grow faster.
From my point of view, UPDATE statement will run perform better right? CMIIW.
Level 51
How about updateOrCreate, which will update the record if it exists, otherwise it will insert new record.
For performance doing only insert will be better, but are you sure you want to keep deleting your records?
Check the docs for more details: https://laravel.com/docs/8.x/eloquent#upserts
1 like
Level 1
@MohamedTammam Yeah, right. Because the info will just last for 1 day or few days maybe. So the record will be overwritten with latest info.
Level 122
if you are considering performance, then updateOrCreate is also two queries. Better to use Upserts which achieves the same in a single operation
4 likes
Please or to participate in this conversation.