I finally found the correct information today to figure out why some kinds of subqueries take forever to come back in mysql. If you are using a subquery with a MYSQL IN() like this:

select o.ack,o.product
from orders o
where o.ack in (
select distinct ack
from 	orders
where  	status in ('Shipped','Cancelled')
group by ack
having 	DATE_ADD( DATE_SUB( now( ) , INTERVAL DAYOFMONTH( now( ) ) - 1 DAY ) , INTERVAL -3 MONTH ) > max(status_date))
)
order by o.ack, o.line

It takes a few minutes to return a result. If you take the same query and reorder it to put the subquery in the from with a join it comes back almost instanty :

select o.ack,o.product
from orders o
inner join (select distinct ack
from 	orders
where  	status in ('Shipped','Cancelled')
group by ack
having 	DATE_ADD( DATE_SUB( now( ) , INTERVAL DAYOFMONTH( now( ) ) - 1 DAY ) , INTERVAL -3 MONTH ) > max(status_date)) old_o
on o.ack = old_o.ack
order by o.ack, o.line

It's interesting on MSSQL that the IN() subquery syntax is much faster.

Here's a link to the bug report:

bugs.mysql.com/bug.php (Thanks Jeremy Pointer :) )

On the heals of GOOGLE Apps having persistent storage Amazon decides to add it as well. This was the only major issue I had with EC2 as I didn't "get" how it would all work with S3. It seems they are planning to add an unformatted harddrive that you can partition and format to your heart's desire. There will even be an API to backup the harddrive to S3.

This is a very exciting development, I can't wait to try it out.

Amazon's Announcment

http://developer.amazonwebservices.com/connect/thread.jspa?threadID=21082

I was very excited my New Mac Book Pro got here yesterday. It is so much faster than my old G4 Powerbook :). My old laptop wrote a lot of great code and it will be fondly remembered.

I was rolling along getting my music and mail copied over ( important stuff first :) ) and having a grand time with the new multi-touch track pad. That I thought I would brave the install of Coldfusion on Leopard.

I figured since there were posts going back to OCT 2007 I'd be safe, by getting my laptop now. How wrong I was. After 7 hours of not working and trying all of the blog posts and suggestions the web had to offer I had almost given up. When I came along this blog post with a video :

www.flashalisious.com/2007/12/14/installing-coldfusion8-on-leopard-using-mamp/

Well that worked after many hours of frustration so kudos for figuring this out and saving the day.

On a side note the weakest part of coldfusion since they have switched to java has been the installer. Even on linux systems they do offically support. I think it really hurts us as a developer community. It's fine if Adobe doesn't support every operating system in th world but it should at least install and function for development. And they do support OS X just not this version. I would have expected them to have had a fix for this by now. It's a huge barrier to developers even more so than the costs associated with buying the server. My New Mac came already working with PHP ....

Oh well off to setup CFECLIPSE :)

*Update 3/19/2008 - I got an email from Adobe for the Beta Test of CF8 Beta 1 waiting to get the download.