Raise your hand if you've ever done this:
At a programming forum that you regularly visit, you see a post asking for help
The post describes a situation that you may not intimately familiar with, or that you know has been covered elsewhere many times, and it is clear a quick Google search will find a good answer.
So, you think of some good key words, perform a few quick searches, examine the results, and determine which of your findings is a good...
Here's a very common situation that is very easy to optimize and simplify, submitted via the mailbag.
Let's say you have a database that contains Companies, Products and Stores. Products and Stores are unique to each company -- i.e., they are not "shared" across companies. read more...