Linux Today: Linux News On Internet Time.
Search Linux Today
Linux News Sections:  Developer -  High Performance -  Infrastructure -  IT Management -  Security -  Storage -
Linux Today Navigation
LT Home
Contribute
Contribute
Link to Us
Linux Jobs


More on LinuxToday


Limiting the Number of Rows in MySQL Result Set

Dec 23, 2010, 15:04 (1 Talkback[s])
(Other stories by Rob Gravelle)

"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: