[Phpmyadmin-devel] MySQL 5.1.23 and information_schema
lists at sebastianmendel.de
Mon Mar 10 13:51:59 CET 2008
Marc Delisle schrieb:
> Sebastian Mendel a écrit :
>> Marc Delisle schrieb:
>>>> -----Original Message-----
>>>> From: Sebastian Mendel <lists at sebastianmendel.de>
>>>> To: phpmyadmin-devel at 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:
>>>> 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
>>> "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.
yes, i think so, i try always, whether I_S or not, to be as specific as
possible with my queries.
More information about the Developers