Re: mysqlshow.c - Modifications - 2nd Try

[Antony T Curtis]

"Claes Månsson" wrote:
> 
> Antony T Curtis skrev:
> >
> > Markus Grundmann wrote:
> >
> > Such a feature as this would have to be a "optional" rather than
> > default.
> >
> > I wouldn't want it to open 400+ tables in a database to find out how
> > many million rows there are...
> 
> Ehrm. Not that big of an issue. From the docs at
>
> <http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#Where_optimizations>
> 
> "COUNT(*) on a single table without a WHERE is retrieved directly from
> the table information"
> 
> As I understand it, this means that the speed of fetching the number of
> records from a table is pretty near constant. A one-record table would
> take the same time as a million-record table...

True, but I still wouldn't want it to open all 400+ tables.

-- 
ANTONY T CURTIS                     Tel: [phone]
Abacus Polar Holdings Ltd           Fax: [phone]
> 
Rule of Creative Research:
> 
	(1) Never draw what you can copy.
> 
	(2) Never copy what you can trace.
> 
	(3) Never trace what you can cut out and paste down.