0

I have 5000 databases on one server.

Switching databases is taking a long time sometimes 2 seconds. (use databaseA)

IT is showing up in a my slow queries log. Is there any way to make this go faster.. some form indexing or some other configuration?

1 Answer 1

1

Short of beefing up your server hardware, you could start splitting off databases to several servers, as 5000 databases on a single server is pretty huge.

Something that will cut your I/O wait, which is most likely an issue is an SSD, but a good one costs hundreds of $.

1
  • 5000 databases doesn't seem like alot to me considering the databases themselves are all pretty small bar a few of them. it doesn't make sense to me that it would take 2 seconds to traverse 5000 databases when it could traverse 5000 rows in a fraction of the time.. Oct 28, 2009 at 15:26

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .