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 are you
this message in context:
http://www.nabble.com/Limit-the-results-of-a-COUNT-tp14549988p14561532.html
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
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
anything to
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/Limit-the-results-of-a-COUNT