We have a large database that we need optimized to work much faster (about 80GB of data, 120,000,000 rows). The structure is below.
 
When we query a single row (LIMIT 1) or a small amount (i.e. LIMIT 0, 30) it runs very fast. But when ever we do something that needs to run through most of [...]

Our SafeID product just mentioned on the home page of Mass High Tech site - http://bit.ly/Nr2jj