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:
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 StudiosReceived on Tue Nov 24 2009 - 18:22:50 CST