Archive for December 10th, 2008
Memo: Avoid Nested Queries in MySQL at all costs
December 10th, 2008 by Scott SelikoffSome of my readers may be aware that nested subqueries such as “SELECT * FROM widgets WHERE id IN (SELECT …)”, don’t work all that well in MYSQL. While the syntax is usually correct, the performance issues in practice can be horrendous. This article delves deeper into this issue, and why MySQL performs so poorly [...]
Posted: 10 December, 2008 in Database.
Tags: Database, JDBC, mysql, nested, queries
Comments: 11