Limiting the Number of Rows in MySQL Result Set

"In the Web 2.0 world where smart phone and Web applications are competing to access terabytes of data, there is a new imperative for speeding up retrieval times as much as the technology permits. Rob Gravelle lists a few coding techniques that we as database administrators and developers can use to whittle down unwieldy results sets into manageable chunks.

"In the Web 2.0 world where smart phone and Web applications are competing to access terabytes of data, there is a new imperative for speeding up retrieval times as much as the technology permits. Other than the obvious solution of beefing up hardware and conduction materials, there are software improvements that can have a measurable impact. For instance, in the front end, searches can be tailored to suit the user's exact requirements, while on the data side, mechanisms can be put in place to send large data sets in chunks or even limit what's returned by using some sort of algorithm for ascertaining relevance of the results. We've seen all of this done in the most successful search engines, such as Google and Bing, to name but a few."

Complete Story

Related Stories:

• Optimizing MySQL Query Retrieval Speed Through Table Joins(Dec 10, 2010)
• Eliminating Duplicate Rows from MySQL Result Sets(Nov 12, 2010)
• How Operator Precedence Affects MySQL SELECT Queries(Sep 22, 2010)
• MySQL SELECT Statement 101(Aug 27, 2010)
• Five Handy Tips for MySQL's Powerful UPDATE Statement (Jul 27, 2010)
• MySQL INSERT Statement Variations(Jun 25, 2010)