Marc Delisle schrieb:

Sebastian Mendel a écrit :

...

Marc Delisle schrieb:

...

...

-----Original Message----- From: Sebastian Mendel lists@sebastianmendel.de To: phpmyadmin-devel@lists.sf.net Date: Sun, 09 Mar 2008 09:45:15 +0100 Subject: Re: [Phpmyadmin-devel] MySQL 5.1.23 and information_schema

Marc Delisle schrieb:

...

Here are guidelines for improved speed accessing information_schema:

http://dev.mysql.com/doc/refman/5.1/en/information-schema-optimization.html

yes, for a long time ... ;-)

but none of the suggested improvements can be used when obtaining whole database list ...

and we always specify as exact as possible what data we want from the I_S

Ok, but here is what MySQL has to say about version 6.0.4 http://dev.mysql.com/doc/refman/6.0/en/news-6-0-4.html "INFORMATION_SCHEMA implementation changes were made that optimize certain types of queries for INFORMATION_SCHEMA tables so that they execute more quickly."

yes ... ok ... two month is a long time for me ... ;-)

and i just wanted to say, that we are already as specific as possible when querieng I_S, and when obtaining the whole database list we can not be more specific - we just want all databases ... :-/

or what did you want to say?

I just wanted to be sure that we already are as specific as possible in the queries, thanks.

ah, ;-)

yes, i think so, i try always, whether I_S or not, to be as specific as possible with my queries.