On Aug 16, 5:19 am, deci...@xxxxxxxxxxx (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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings