MySQL “IN” queries terribly slow with subquery but fast with explicit values

by

Subqueries execute every time you evaluate them (in MySQL anyway, not all RDBMSes), i.e. you’re basically running 7 million queries! Using a JOIN, if possible, will reduce this to 1. Even if adding indexing improves performance of those, you’re still running them.

More Related Contents:

  1. How to do the Recursive SELECT query in MySQL?
  2. JOIN queries vs multiple queries
  3. MySQL indexes – what are the best practices?
  4. Subqueries with EXISTS vs IN – MySQL
  5. mysql select from n last rows
  6. Difference in MySQL JOIN vs LEFT JOIN
  7. 60 million entries, select entries from a certain month. How to optimize database?
  8. Checking multiple columns for one value
  9. Mysql Improve Search Performance with wildcards (%%)
  10. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  11. mysql, ifnull vs coalesce, which is faster?
  12. Higher cardinality column first in an index when involving a range?
  13. MySQL: Can I do a left join and pull only one row from the join table?
  14. How to optimise MySQL queries based on EXPLAIN plan
  15. How to estimate SQL query timing?
  16. Deleting millions of rows in MySQL
  17. MySQL: is a SELECT statement case sensitive?
  18. Check overlap of date ranges in MySQL
  19. How to execute a MySQL command from a shell script?
  20. Select most common value from a field in MySQL
  21. MySQL update a joined table
  22. Returning the ‘last’ row of each ‘group by’ in MySQL
  23. mysql configuration stops at “starting server”
  24. Is it possible to reference one column as multiple foreign keys?
  25. No Entity Framework provider found for ‘MySql.Data.MySqlClient’ ADO.NET provider
  26. How to Import Multiple csv files into a MySQL Database
  27. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  28. Data truncated for column?
  29. MySQL concurrency, how does it work and do I need to handle it in my application
  30. What is the MAX number if I store int(255) in MySQL?

Leave a Comment