Re: Yet Another COUNT(*)...WHERE...question

"Scott Marlowe" wrote:

>FYI, I went to the ebay page you posted, which listed something like
>98011 pages, and asked for page 96000. It searched for about a minute
>and timed out with the error message
>
>There was a problem executing your request. Please try again.
>
>Tried it again, twice, about 5 minutes apart, and got the same error each time.
>
>So I'm guessing that ebay is better at making your THINK it has the
>exact count than actually having the exact count.

Well that depends on the current traffic on eBay. It worked allright this
afternoon (GMT), but I get the same error message now (btw, a few years ago
you only got an error message if a search retruned more than 1M items).

Try it with this search: <http://search.ebay.com/new> which gives about 2.2M
items.

Rainer