We have thousands of create and drop tables daily.This seems strange.
Are these temp/work tables? Then maybe they can be created
as isam or memory tables.
If not, can you use one big table instead of thousands?
The big table would have an indexed key which says what data
set (previously in separate table) in accessed.
Pekka Nousiainen, Software Engineer
MySQL AB, www.mysql.X.com
firstname.lastname@example.org +46 (0) 73 068 4978