let $i=2000; while ($i) { dec $i; eval CREATE DATABASE db$i; eval CREATE TABLE db$i.t01( a INT ); eval CREATE TABLE db$i.t02( a INT ); eval CREATE TABLE db$i.t03( a INT ); eval CREATE TABLE db$i.t04( a INT ); eval CREATE TABLE db$i.t05( a INT ); eval CREATE TABLE db$i.t06( a INT ); eval CREATE TABLE db$i.t07( a INT ); eval CREATE TABLE db$i.t08( a INT ); eval CREATE TABLE db$i.t09( a INT ); eval CREATE TABLE db$i.t10( a INT ); eval CREATE TABLE db$i.t11( a INT ); eval CREATE TABLE db$i.t12( a INT ); eval CREATE TABLE db$i.t14( a INT ); eval CREATE TABLE db$i.t15( a INT ); } USE information_schema; --start_timer SELECT table_name, table_comment FROM tables WHERE table_schema = 'db250' AND table_name = 't08'; --end_timer let $i=2000; while ($i) { dec $i; eval DROP DATABASE db$i; }