I have been at Equator for 2.5 years, currently a Senior Enterprise Architect and I'm having a blast working here. We have multiple openings in Los Angeles, Irvine, Plano, and Seattle. In addition to developers, we also need Business Analysts and Technical Project Managers. If you're interested in working with a leader in the Real Estate and Financial Services Industry, please read on.
Thanks to Michael and Judith Dinowitz, there is a new ColdFusion book on the market, Adobe ColdFusion Anthology, and I'm glad to have had a hand in it.
I've been sitting on this for over a year now it's finally here! The book is an anthology of articles from Fusion Authority magazine. Chapter 11 of the book is my contribution, "You Might Have a Performance Bottleneck If". Written in the mood of Jeff Foxworthy, I outline 12 common problems in web applications (not just CF applications) that can be easily solved by the proper use of a database.
What are you waiting for? Pick up your copy of Adobe ColdFusion Anthology today! :)
Sorry I've been off the radar for so long, but I've had a heck of a year. I'll be posting a few things shortly, but in the meantime you can take a look at what started out as a blog post and ended up as a published article. My article, "You Might Have a Performance Bottleneck If . . ." has just been published in the latest Fusion Authority Quarterly Update. Yes, you read that correctly. There's a new FAQU and you can read it right now.
Earlier today, Ray Camden posted a quick ColdFusion-centric solution to showing only the Nth records of a query. His solution is fine, but I wonder how it would perform for large queries on a site under high load. Here's a database-centric solution that pulls back every Nth record, allowing CF to just display the final record set.
I know there are a lot of tutorials that use this technique. I also know there's a lot of inherited code (in any language) that contains this SQL. I also also know that - years ago - I too was a slave to SELECT MAX(id). But this is the 21st century and you need to stop using it.