MySQL performance

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
nmotion
Forum Commoner
Posts: 32
Joined: Wed Jan 22, 2003 6:53 am

MySQL performance

Post by nmotion »

Are there any performance gain in spreading your tables over more than one MySQL database or?

Any insight on this is welcome and appreciated.
User avatar
DaZZleD
Forum Commoner
Posts: 38
Joined: Tue Jan 07, 2003 5:39 am

Post by DaZZleD »

mysql works with copy of tables you use. therefore if you use many tables and keep switching from one to another the mysql has to unload one in order to make room for the other.
also mysql uses indexes for referencing data entries so the performance is good with large tables too. however you cannot make very large tables for (once loaded into memory) they might occupy all the free memory and other queries (from other users, on other tables) will have to wait untill the memory is freed.

you have to try and find a ballance between the two.
Post Reply