Disadvantages of quoting integers in a Mysql query?

by

The performance cost is that whenever mysql needs to do a type conversion from whatever you give it to datatype of the column. So with your query

SELECT col1,col2,col3 FROM table WHERE col1=’3′;

If col1 is not a string type, MySQL needs to convert ‘3’ to that type. This type of query isn’t really a big deal, as the performance overhead of that conversion is negligible.

However, when you try to do the same thing when, say, joining 2 table that have several million rows each. If the columns in the ON clause are not the same datatype, then MySQL will have to convert several million rows every single time you run your query, and that is where the performance overhead comes in.

More Related Contents:

  1. MyISAM versus InnoDB [closed]
  2. How can i optimize MySQL’s ORDER BY RAND() function?
  3. MYSQL OR vs IN performance
  4. Why does MYSQL higher LIMIT offset slow the query down?
  5. How to Perform an UPSERT so that I can use both new and old values in update part
  6. Is there a REAL performance difference between INT and VARCHAR primary keys?
  7. MySQL: Fastest way to count number of rows
  8. Why is MySQL InnoDB insert so slow?
  9. MySQL vs MongoDB 1000 reads
  10. MySQL stored procedures use them or not to use them
  11. UUID performance in MySQL?
  12. MySQL “IN” operator performance on (large?) number of values
  13. How can I speed up a MySQL query with a large offset in the LIMIT clause?
  14. Optimal MySQL settings for queries that deliver large amounts of data?
  15. What is better in MYSQL count(*) or count(1)?
  16. DOs and DONTs for Indexes [closed]
  17. MySql views performance [closed]
  18. MySQL performance: multiple tables vs. index on single table and partitions
  19. MySQL view performance
  20. “SELECT COUNT(*)” is slow, even with where clause
  21. Higher cardinality column first in an index when involving a range?
  22. Does Order of Fields of Multi-Column Index in MySQL Matter
  23. MySQL load data infile – acceleration?
  24. sql group by versus distinct
  25. is php sort better than mysql “order by”?
  26. How can “set timestamp” be a slow query?
  27. Would it help to add index to BIGINT column in MySQL?
  28. ALTER TABLE ADD COLUMN takes a long time
  29. Why is connecting to MySQL server so slow?
  30. Optimizing MySQL for ALTER TABLE of InnoDB

Leave a Comment