Does it make sense to add the smaller and much lesser frequented 5 databases (size from 100Kb to 2Mb) as new tables into the WWF main database (60+ Mb)? Would performance increase? What issues must I take into consideration before migrating the 6 databases into 1, any pros or contras?

 

Right now each page uses 3-5 different DSN-connections (I know that DSN-less is usually faster, but with our host it does not work very well) so using only one connection to the same database should be faster, at least I would assume so. Is that correct?

 

We are getting hosted on a shared Windows 2003 Server.

 

All further informations would be greatly appreciated.

 

 

On the other hand, the entire access db is loaded into memory each time it's opened - regardless of connection method. It would seem like a waste to load the infrequently used data for pages where it will never be referenced.

 

We have been using DSN-less connections before and I am well aware that they are faster. But since we changed the host the DSN-less connections became extremely slow so we had to switch to DSN-connections.

 

Although our site is not really fast, it is using a 60MB Access database, so I will not complain. Before we had a 120MB database, without any significant performance changes. (SQL is not an option).