'Query' Tag

  • Does Size or Type Matter?

    July 27, 2010

    MySQL seems to be happy to convert types for you. Developers are rushed to complete their project and if the function works they just move on. But what is the costs of mixing your types? Does it matter if your are running across a million rows or more? Lets find out. Here is what the [...]

  • Single Query Profiling

    February 26, 2010

    Every wounder what was taking MySQL so long to run your query.  You can ask it. mysql > set profiling=1; mysql> SELECT * FROM country WHERE city like ‘okla’  order by name; mysql> SHOW PROFILES; You should now see a table with a single row, with the number 1 to the left of your query. [...]

 



Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org
Creative Commons License
MySQL Fan Boy by Mark Grennan is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.
HOME