any way to speed up count(*)?

From: <mh_at_pixar.com>
Date: 25 Nov 2009 00:22:50 GMT
Message-ID: <4b0c78da$0$31889$c32e2966_at_unlimited.newshosting.com>



I've got an application being put together with cake/php. It's pretty nice, but their data pager does this:

    SELECT COUNT(*) AS COUNT
    FROM foo f
    LEFT JOIN bar b
    ON (f.asset_group_id = b.asset_group_id)

    WHERE 1                    = 1

Any way possible to speed this up?

Many TIA!
Mark

-- 
Mark Harrison
Pixar Animation Studios
Received on Tue Nov 24 2009 - 18:22:50 CST

Original text of this message