Showing entries 1 to 1
Displaying posts with tag: Query OptimizationPerformanceOurSQL Database Podcastmysqlpodcast (reset)
OurSQL Episode 22: Things To Avoid With MySQL Queries

mysql podcast

Feature:

Things to Avoid in Queries
Subqueries and Correlated subqueries
http://dev.mysql.com/doc/refman/4.1/en/correlated-subqueries.html

Jan Kneschke’s post on Groupwise Maximum:
http://jan.kneschke.de/projects/mysql/groupwise-max

Calculated comparisons do not use indexes

INSERT IGNORE
REPLACE
INSERT…ON DUPLICATE KEY

Feedback:

Email podcast@technocation.org

call the comment line at +1 617-674-2369

use Odeo to leave a voice mail through your …

[Read more]
Showing entries 1 to 1