From: botp Date: 2010-12-01T21:18:05+09:00 Subject: Re: A algorithm for finding the number On Wed, Dec 1, 2010 at 3:50 PM, zuerrong wrote: > So I was thinking loading the whole data into memory, discarding > mysql, and find a algorithm for doing it quickly. > Any suggestion try doing a soft binary search on the first column best regards -botp