Here are guidelines for improved speed accessing information_schema:
http://dev.mysql.com/doc/refman/5.1/en/information-schema-optimization.html
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