If exact number isn't important, you might want to try table_rows in information_schema.tables or show table status.
On Dec 21, 2007 7:53 PM, Urms <[EMAIL PROTECTED]> wrote: > > Hi, > > My task is to limit calculation of total number of items in the database > that satisfy certain conditions. I join two tables using WHERE and there are > millions of records as the result. When I do SELECT count(*) .... it takes > really too long. The table has appropriate indexes and I experimented with > replacing the conditions, etc., so I don't think there is a way to make it > work any faster. In my case it would be anough to say that there are "more > than e.g. 50 000" of items instead of calculating the exact quantity. My > question is how to apply a certain limit to count() function in order it > would either return the real quantity if it is smaller than the limit or > return the limit and stop further calculation, quite same as when using > SELECT * FROM ... LIMIT 0, 100 > > Another option could be estimating approximate quantity in the result but it > seems to me much more complex and I honestly don't know where to start from. > > Thanks! > -- > View this message in context: > http://www.nabble.com/Applying-LIMIT-to-SELECT-count%28*%29-tp14453544p14453544.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 PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
