On Aug 16, 5:19 am, deci(dot)(dot)(dot)(at)decibel(dot)org (Decibel!) wrote:
> On Thu, Aug 16, 2007 at 12:12:03PM +0200, Rainer Bauer wrote:
> > "Scott Marlowe" wrote:
> > But if you go to eBay, they always give you an accurate count. Even if the no.
> > of items found is pretty large (example: <http://search.ebay.com/new>).
>
> And I'd bet money that they're using a full text search of some kind to
> get those results, which isn't remotely close to the same thing as a
> generic SELECT count(*).
http://www.addsimplicity.com/downloads/eBaySDForum2006-11-29.pdf
Search for the text "Scaling Search".
Interesting stuff.