2 ms·
Sometimes it’s still the app: rows = select all accounts for each row in rows: update row But that’s not necessarily a PHP problem. N+1 queries a
by imron 7mo ago
Sometimes it’s still the app:
rows = select all accounts
for each row in rows:
update row
But that’s not necessarily a PHP problem. N+1 queries are everywhere.
- silon42 7mo agoDepending on what you are doing, the above is not necessarily bad.. often much better than an SQL that locks an entire table (potentially blocking the whole DB, if this is one of the key tables).