[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