From: "Scott Gifford" > SELECT COUNT(*) FROM firebase_content; > > to get the count. That's very fast; it comes from the table summary > information, IIRC. I use a similar solution for a similar problem, > and have had great luck with it. This is true for MyISAM tables, but e.g. InnoDB does *not* store the total number of records per table seperately. A SELECT COUNT(*) on InnoDB will result in a real row count...
Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]