On Dec 31, 2007 3:05 PM, donr2020 <[EMAIL PROTECTED]> wrote:
> Sorry, I didn't type the subqueries quite correctly. They all have the same
> WHERE part (in this case, "WHERE Col1 = X" that essentially "joins" all the
> queries.
It still doesn't make sense to me. Count queries don't return
anythin
actually be faster though.
>
> - Perrin
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
View this message in context:
http://www.nabble.com/Limit-the-result
On Dec 30, 2007 1:50 PM, donr2020 <[EMAIL PROTECTED]> wrote:
> Our search engine does a master query INNER JOINed to a series of COUNT (*)
> subqueries that return what the number of results would have been had the
> user chosen different "filters" (or no filter at all). As an example:
Hmm. Why a
illion
records (and rapidly growing), and if TotCount is over about 50,000, the
query is unacceptably slow. We need to LIMIT the subqueries to some maximum
count (stop counting at, say, 50,000). Does anyone know a way to do this?
Thanks
--
View this message in context:
http://www.nabble.com/Lim