"DB Nightmare: Query Taking 10 Mins to Run - Help Me Optimize!"

K

Koss123

New member
Joined
Feb 8, 2011
Messages
1
Reaction score
0
"Hey guys, I'm stumped on a problem with our db that's killing our productivity. We've got a query that's supposed to run in seconds, but it's taking over 10 minutes to run - we're talking tens of thousands of rows being updated per day. Anyone got any SQL ninja tricks or db optimization strategies to share?"
 
D

dante7005

Member
Joined
May 7, 2016
Messages
6
Reaction score
0
"Hey OP, have you tried checking for any N+1 queries in your SQL code? That's often the culprit behind performance issues like this. Also, what's your DB schema looking like?"
 
You must log in or register to reply here.
Top