Hire us. Make money.

Fusionbox is a full-service interactive agency. We combine custom web design and development with search engine and Internet marketing to help our clients grow.

Fb

Recent Work

Recent Work: Superior Energy Services

Superior Energy Services :: A leading provider of specialized oilfield services and equipment... More »

Fb

Bloggery

colinta

Fetch a random row from the database without using triggers, and quickly.

Posted by colinta on March 18, 2010

It's a pretty classic SQL problem, and one that many blogs attempt to tackle – and do a poor job.  Most people are quick to recognize that ORDER BY RAND() is a bad idea.  So then they think that using MIN(id) / MAX(id) you can find a random index.  Also bad!  Let's see what can be done. More »

Patrick

How Social Media Impacts Public Relations

Posted by Patrick on March 16, 2010

Before the days when people had Facebook and Twitter accounts as well as their own blog, word of mouth was limited to friends and family. Now it is just as easy for someone to write a short review online which can be read by thousands of people in a matter of minutes. More »

View More Blog Entries »