brett's blog

Creating a learning blog

Posted Fri, 04/22/2011 - 10:28 by brett

So I'm calling this my learning blog. It will basically be where I just post stuff about what I'm learning. Should be fun...

Group By, Order By, and Limit

Posted Thu, 06/19/2008 - 19:22 by brett

So I had a question while optimizing some Mysql queries. What is the right order for the 3 commands I needed in this query: GROUP BY, ORDER BY, and LIMIT?

MySQL query optimization - indexing

Posted Thu, 06/19/2008 - 19:19 by brett

Well, in school we talked so much about tuning, I even took a class that devoted part of it to MySQL tuning, but I had yet to see a need for it until today. We have a site that wanted an area to each video page that pulled in content like Amazon.com. We titled the area "People who viewed this also viewed" and we were pulling in content that was seen by other users and highly rated. So, here's the sql I came up with:

SELECT path, COUNT(path) as count FROM accesslog WHERE uid IN (SELECT uid FROM accesslog WHERE path='*****' AND uid !=0) GROUP BY path ORDER BY count

Add a visitor's IP address to the theme layer

Posted Tue, 05/27/2008 - 13:52 by brett

I had a client ask me to put the visitor's IP address onto the page, and here's the process I went through to do it:

DrupalCon Boston 2008

Posted Wed, 03/05/2008 - 11:38 by brett

I am in Boston this week at a Drupal conference. I am attending tons of sessions and learning all sorts of awesome stuff, and blogging about it (sometimes just dumping my notes) at http://drupalcon.brettevanson.com

Please go comment if you are there or have questions.