Does anyone know about the effects to performance of dividing one database which is accessed by another into 3 databases. My reason for doing so is to make the databases a little more organized and manageable and to maintain smaller file sizes.
Unfortunately I will not be able to migrate to SQL for atleast another 9 months.
The current database includes over 75 tables and is over 800 mb. The split databases will be appr:
20 tables 65mb
40 tables 180mb
15 tables 400mb
The other side benefit is that most of the users will regularily be accessing the smallest and one of the other two databases. Most will not be accessing all three.
Will performance improve or decline?