Monthly Archives: August 2007

OurSQL Episode 22: Things To Avoid With MySQL Querie

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 computer:
http://odeo.com/sendmeamessage/Sheeri

or use the Technocation forums:
http://www.technocation.org/forum

Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 22: Things To Avoid With MySQL Querie

OurSQL Episode 21: The Rise of the MySQL DBA

Paul Vallee is back for this non-technical podcast about the special creature that is the MySQL DBA.
News:
October 2006 Enterprise/Community Split announcement
http://www.planetmysql.org/entry.php?id=4393
Current clarification of Enterprise/Community s… Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 21: The Rise of the MySQL DBA

OurSQL Episode 20: The Pythian Group

In this less technical episode we interview Paul Vallee, where he explains in depth about the Pythian Group.
Special thanks to folks who have linked to the podcast:
WebDevRadio
http://www.webdevradio.com
Episode 34, July 9th, in which Michael mentions … Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 20: The Pythian Group