Whoooo boy, that was a bad pun of a title; I think I may have actually topped Count Rowula. Anyway, today's example is from Lynn Rogala, who was tasked with figuring out how to merge three additional marketing databases into their existing system. The data folks tried just merging the data, but that caused the system to become incredibly slow. After a little bit of digging, Lynn discovered that the original programmers didn't really believe in using the WHERE clause when it came to SELECT statements ...

ResultRecord getDetail(String contactId)
{
    String sql = "select * from contacts";
    ResultSet resultSet = GetResultSetFromSql(sql);
    while(resultSet.hasNext())
    {
        ResultRecord record = resultSet.next();
        if(record.getContactId().equals(contactId))
        {
              return record;
        }
    }

}

[Advertisement] BuildMaster allows you to create a self-service release management platform that allows different teams to manage their applications. Explore how!