Oh, I misunderstood,sorry.
Using summary tables doesn't work for you?
On Dec 22, 2007 3:00 AM, Urms <[EMAIL PROTECTED]> wrote:
>
> The problem is that there are certain conditions after WHERE different for
> each query and the results number can be very different.
> --
> View this message in conte
The problem is that there are certain conditions after WHERE different for
each query and the results number can be very different.
--
View this message in context:
http://www.nabble.com/Applying-LIMIT-to-SELECT-count%28*%29-tp14453544p14459808.html
Sent from the MySQL - General mailing list arc
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 jo
