[thelist] eval(eval())!
Shashank Tripathi
sub at shanx.com
Wed Jul 17 03:42:00 CDT 2002
Thanks Jeff & Simon for the patient explanations about eval(). Simon, the
sprintf idea was neat! Duly noted and quickly shared...it even looks
prettier, let alone the performance glitches.
Cheers,
Shanx
<tip type="Mysql InnoDB tables, aggregate functions" author="Shanx">
If you settled for InnoDB tables in your database because you wanted
row-level locking and/or transations, note that aggregation functions will
cost a lot because in InnoDB tables each row will be checked. For instance,
select count(*) from customers;
..will take a lot of time if 'customers' table is a large one. If you don't
mind an *approximate* alternative to this, you could try the "show table"
command which provides only an estimate of the number of rows in the table
but is much, much faster:
show table status like 'customers';
More info about the SHOW TABLE command:
http://www.mysql.com/doc/S/H/SHOW_TABLE_STATUS.html
</tip>
More information about the thelist
mailing list