• Subscribe to the RSS feed!
  • Subscribe by Email
  • home
  • blog
  • dev
  • Recent Posts

    • Ze Balkanic Tweetup
      • on May 31, 2009
    • Moblin, Linux for netbooks
      • on May 21, 2009
    • Back
      • on
    • Happy birthday, dear magician…
      • on May 10, 2009
    • Wordpress as CMS tutorial
      • on March 14, 2009
    • New blog - Try Open Source
      • on March 11, 2009
    • Online resources for Zend Framework
      • on March 3, 2009
    • pywst - setting up web projects quickly
      • on February 22, 2009
    • Full Circle Magazine
      • on February 8, 2009
    • Trac on Ubuntu
      • on January 27, 2009
  • Recent Comments

    • Jason Gilmore
      • on June 23rd @ 5:04 am
    • slawek
      • on June 11th @ 1:29 am
    • igor
      • on June 7th @ 9:56 pm
    • Swizec
      • on June 1st @ 11:18 pm
    • Robert
      • on June 1st @ 8:12 pm
    • Eniac
      • on June 1st @ 2:17 pm
    • -1-
      • on May 31st @ 11:04 pm
    • Robert
      • on May 31st @ 10:54 pm
    • Swizec
      • on May 31st @ 10:27 pm
    • blackshtef
      • on May 31st @ 8:14 pm
  • Find me on

    • DZone
    • Google Code
    • Google Reader
    • Last.fm
    • StumbleUpon
    • Twitter
    • Vimeo
  • Friends and Blogs

    • Andrew Taylor
    • Andy Sowards
    • Bojan Pejić
    • Eran Galperin
    • Graham Smith
    • Jani Hartikainen
    • Jasper Tandy
    • Matthew Turland
    • Matthew Weier O’Phinney
    • Miff
    • Miloš Ćuković
    • Nebojša Radović
    • Nemanja Avramović
    • Nemanja Tobić
    • Nikola Krajačić
    • Nikola Plejić
    • Pádraic Brady
    • Rob Allen
    • Swizec Teller
    • Vladimir Stanković
    • WeAreJustCreative
    • Željko Stevanović
  • I use

    • 960 Grid System
    • jQuery
    • Notepad++
    • Subversion
    • Trac
    • Vim
    • Zend Framework
  • Tags

    • about
    • php
    • random
    • example
    • framework
    • zend
    • ubuntu
    • site
    • blog
    • introduction
    • wordpress
    • linux
    • apache
    • setup
    • lamp
    • svn
    • open source
    • registration
    • facebook
    • comic
  • Categories

    • Blablabla
    • Development
    • Free time
    • Places on the web
    • Programming
    • Software
  • Photos

    Connections.
    Some of the preinstalled applications.
    Done. It took around 6 minutes to install.
    A warning that the HDD must be partitioned

  • Archives

    • May 2009
    • March 2009
    • February 2009
    • January 2009
    • December 2008
    • November 2008
    • October 2008
    • September 2008

Optimizing MySQL and a Zend_Db_Profiler example

by Robert Basic on October 13th, 2008

Last night I came across on a post on TechFounder, about using Zend_Db_Profiler and a good example with real data on optimizing MySQL queries. For “geeks” who SQL speak fluently this will probably be no new stuff, but for great number of web developers (me included!) this will probably come in handy.

Cheers!

Share this post:
  • Digg
  • description
  • del.icio.us
  • StumbleUpon
  • Facebook
  • Reddit
  • TwitThis
  • Google
  • E-mail this story to a friend!
Tags: framework, mysql, optimizing, profiler, zend.
Categories: Development, Places on the web.
Subscribe to the feed.

Comments: 2

Grab the comments feed

  • Eran Galperin

  • October 14th, 2008

Thanks for the mention Robert :)
I have a couple more MySQL optimization posts coming up, hope they’ll measure up.

I really like your blog design, so send my regards to your designer ;)

  • Robert

  • October 14th, 2008

Hi Eran!
No problem, can’t wait for the new posts :)

I’m glad you like the design, will pass it on to the lead designer :)

Cheers mate!

Leave a Reply

 

Robert Basic © 2008 — 2009
Design & graphics by: Livia Radvanski
Coded by: Robert Basic
Home page last updated on January 3rd, 2009.
Frameworks used: Zend Framework, jQuery, 960 Grid System
Blog is powered by Wordpress
Subscribe: Entries — RSS & Comments — RSS