sql,query At 21:50 -0300 7/2/02, Crercio O. Silva wrote: >PS: SELECT COUNT(*) FROM table is working just fine, but on InnoDB tables >with large number of rows (my tables have -+ 300000 records each) it take a >few seconds to get the results. >This is not a big issue for me, but I'd like to confirm that.
Yes, this will happen with both InnoDB and BDB tables, which requlre a full table scan to evaluate COUNT(*), even with no WHERE clause. MyISAM and ISAM optimize that special case and return almost instantaneously. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
