Hi.
COUNT(*) is optimised to return the result very quickly for MyISAM tables,
as the quantity of rows is stored and updated separately. (Not true for other table
types, though).
So in most cases use it.
Rob Best <[EMAIL PROTECTED]> wrote:
> I have a database that contains a cable of
I have a database that contains a cable of 'customers'. 'Customers'
does not change on a regular basis but is queried frequently so I have
setup a 'customers_cache' table, which is exactly the same as
'customers', except 'customers_cache' is a memory based table. Before
doing a query on 'custom
