Fixing Slow UPDATE Queries — Full Breakdown & Transcript

The innocent-looking query that slowed down our database

0h 14m video Published Jul 28, 2026 Transcribed Aug 3, 2026 Tideways Tideways
Intermediate 5 min read For: PHP developers with experience in MySQL and Symfony, interested in database performance optimization.
AI Trust Score 75/100
⚠️ Average / Some Fluff

"Title accurately describes the content; delivers a clear explanation and practical solutions."

Performance

Snapshot 2026-11-18

Views
337
Avg views / hour
0.1
lifetime average since publish
Recent velocity
0.0
+0 views over 24h (2026-11-17 → 2026-11-18)
Vs channel baseline
0.5×
Channel median
712
over 20 comparable videos

Views over time

Performance history

Every observation TubeSum recorded, plotted as measured.

The vertical axis starts at 171, not zero, so later observations stay readable.

Views over time — 84 observed points, 179 to 337 views 171 232 293 354 Aug 3, 2026 · 179 views Aug 5, 2026 · 185 views Aug 7, 2026 · 189 views Aug 8, 2026 · 197 views Aug 9, 2026 · 202 views Aug 10, 2026 · 205 views Aug 11, 2026 · 211 views Aug 17, 2026 · 238 views Aug 18, 2026 · 240 views Aug 27, 2026 · 267 views Aug 31, 2026 · 282 views Sep 1, 2026 · 285 views Sep 4, 2026 · 291 views Sep 5, 2026 · 293 views Sep 7, 2026 · 297 views Sep 9, 2026 · 300 views Sep 11, 2026 · 303 views Sep 12, 2026 · 306 views Sep 13, 2026 · 306 views Sep 14, 2026 · 308 views Sep 15, 2026 · 311 views Sep 16, 2026 · 314 views Sep 17, 2026 · 315 views Sep 18, 2026 · 317 views Sep 19, 2026 · 317 views Sep 20, 2026 · 316 views Sep 21, 2026 · 317 views Sep 22, 2026 · 320 views Sep 23, 2026 · 320 views Sep 24, 2026 · 322 views Sep 25, 2026 · 323 views Sep 26, 2026 · 323 views Sep 27, 2026 · 323 views Sep 28, 2026 · 323 views Sep 29, 2026 · 323 views Sep 30, 2026 · 323 views Oct 1, 2026 · 323 views Oct 2, 2026 · 323 views Oct 3, 2026 · 323 views Oct 4, 2026 · 323 views Oct 5, 2026 · 323 views Oct 6, 2026 · 323 views Oct 7, 2026 · 323 views Oct 8, 2026 · 323 views Oct 9, 2026 · 323 views Oct 10, 2026 · 323 views Oct 11, 2026 · 323 views Oct 12, 2026 · 323 views Oct 13, 2026 · 323 views Oct 14, 2026 · 324 views Oct 15, 2026 · 324 views Oct 16, 2026 · 324 views Oct 17, 2026 · 326 views Oct 18, 2026 · 327 views Oct 19, 2026 · 327 views Oct 20, 2026 · 327 views Oct 21, 2026 · 330 views Oct 22, 2026 · 331 views Oct 23, 2026 · 331 views Oct 24, 2026 · 331 views Oct 25, 2026 · 332 views Oct 26, 2026 · 332 views Oct 27, 2026 · 332 views Oct 28, 2026 · 334 views Oct 29, 2026 · 334 views Oct 30, 2026 · 335 views Oct 31, 2026 · 335 views Nov 1, 2026 · 335 views Nov 2, 2026 · 335 views Nov 3, 2026 · 335 views Nov 4, 2026 · 335 views Nov 5, 2026 · 335 views Nov 6, 2026 · 335 views Nov 7, 2026 · 335 views Nov 8, 2026 · 336 views Nov 9, 2026 · 336 views Nov 10, 2026 · 336 views Nov 12, 2026 · 336 views Nov 13, 2026 · 336 views Nov 14, 2026 · 337 views Nov 15, 2026 · 337 views Nov 16, 2026 · 337 views Nov 17, 2026 · 337 views Nov 18, 2026 · 337 views Aug 3 Oct 6 Nov 18

Based on 84 observations · last observed Nov 18, 2026 · solid lines connect consecutive measurements (≤2 days apart); dashed lines span days TubeSum did not measure. · vertical axis focused on the observed range (starts at 171)

Show observation history · 84 measurements · last 2026-11-18

Exact daily observations; gaps mean no observation was taken that day.

Date Views Avg views / hour Channel median
2026-11-18 337 0.1 712
2026-11-17 337 0.1 712
2026-11-16 337 0.1 712
2026-11-15 337 0.1 712
2026-11-14 337 0.1 712
2026-11-13 336 0.1 712
2026-11-12 336 0.1 712
2026-11-10 336 0.1 712
2026-11-09 336 0.1 712
2026-11-08 336 0.1 712
2026-11-07 335 0.1 712
2026-11-06 335 0.1 712
2026-11-05 335 0.1 712
2026-11-04 335 0.1 712
2026-11-03 335 0.1 712
2026-11-02 335 0.1 712
2026-11-01 335 0.1 709
2026-10-31 335 0.1 709
2026-10-30 335 0.1 709
2026-10-29 334 0.1 709
2026-10-28 334 0.2 709
2026-10-27 332 0.2 709
2026-10-26 332 0.2 709
2026-10-25 332 0.2 709
2026-10-24 331 0.2 757
2026-10-23 331 0.2 757
2026-10-22 331 0.2 757
2026-10-21 330 0.2 757
2026-10-20 327 0.2 757
2026-10-19 327 0.2 757
2026-10-18 327 0.2 757
2026-10-17 326 0.2 757
2026-10-16 324 0.2 757
2026-10-15 324 0.2 757
2026-10-14 324 0.2 757
2026-10-13 323 0.2 757
2026-10-12 323 0.2 757
2026-10-11 323 0.2 757
2026-10-10 323 0.2 757
2026-10-09 323 0.2 757
2026-10-08 323 0.2 757
2026-10-07 323 0.2 757
2026-10-06 323 0.2 757
2026-10-05 323 0.2 757
2026-10-04 323 0.2 757
2026-10-03 323 0.2 757
2026-10-02 323 0.2 757
2026-10-01 323 0.2 757
2026-09-30 323 0.2 757
2026-09-29 323 0.2 757
2026-09-28 323 0.2 757
2026-09-27 323 0.2 757
2026-09-26 323 0.2 757
2026-09-25 323 0.2 757
2026-09-24 322 0.2 690
2026-09-23 320 0.2 690
2026-09-22 320 0.2 690
2026-09-21 317 0.2 690
2026-09-20 316 0.2 690
2026-09-19 317 0.2 690
2026-09-18 317 0.3 690
2026-09-17 315 0.3 690
2026-09-16 314 0.3 690
2026-09-15 311 0.3 690
2026-09-14 308 0.3 690
2026-09-13 306 0.3 690
2026-09-12 306 0.3 690
2026-09-11 303 0.3 690
2026-09-09 300 0.3 663
2026-09-07 297 0.3 663
2026-09-05 293 0.3 663
2026-09-04 291 0.3 663
2026-09-01 285 0.3 663
2026-08-31 282 0.3 663
2026-08-27 267 0.4 663
2026-08-18 240 0.5 597
2026-08-17 238 0.5 597
2026-08-11 211 0.6 597
2026-08-10 205 0.7 597
2026-08-09 202 0.7 597
2026-08-08 197 0.8 597
2026-08-07 189 0.8 597
2026-08-05 185 1.0 597
2026-08-03 179 1.2 597

Engagement

Audience reaction — separate from the performance metrics above.

Engagement Rate
ⓘ
8.9%
Average
Likes
29
Comments
1
Dislikes
ⓘ
N/A
No estimate
Views / Subscribers
ⓘ
0.30×
True Sentiment
ⓘ
N/A
No rating yet

More from Tideways

View all