Queries with OR conditions are commonly used to implement business logic. However, it might be slower than we expected. Although the query below scans only 1 million rows, it runs for 6,7254 seconds.# User@Host: msandbox[msandbox] @ localhost [127.0.0.1] Id: 188 # Schema: Last_errno: 1160 Killed: 0 # Query_time: 67254.081455 Lock_time: 0.000006... Weiterlesen: Why MySQL OR is slower than IN
Intelligence View
⚡ tsecurity.de Intelligence
Why MySQL OR is slower than IN
Queries with OR conditions are commonly used to implement business logic. However, it might be slower than we expected. Although the query below scans only 1…
Quelle & Fakten · 1 Min. Lesezeit
Quelle: Blog - Percona (percona.com)
Rubrik: Sichere Programmierung
Security Briefing Kostenlos · 1-Klick-Abmeldung
Intelligence Digest — kostenlos
Täglich die wichtigsten Security-News · jederzeit abbestellbar