[Phpmyadmin-devel] Some bugs in master

Michal Čihař michal at cihar.com
Tue Jul 12 14:49:36 CEST 2011


Hi

Dne Tue, 12 Jul 2011 13:08:37 +0300
Tyron Madlener <tyronx at gmail.com> napsal(a):

> And one more suggestion:
> 
> Counting rows in big tables that use CSV as Engine (such as the
> general_log) seem very slow. Maybe rows should not be counted
> automatically for CSV Tables and only done upon user request.
> In my test I counted 36k rows on the demo server, that takes around
> 250ms, so imagine the general_log running all day. Then you will have
> 1mil+ rows, which then requires ~6-8 seconds to count.

There is already similar logic for InnoDB or views, so only another
engine should be added here.

-- 
	Michal Čihař | http://cihar.com | http://blog.cihar.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20110712/978c17d5/attachment.sig>


More information about the Developers mailing list