Database structure and performance
I'am looking form some experiences or proffesional advice. I created system from cca 20 database fields. Each contain one or two tables. There is one main field which contain all layouts scripts and main setting data. All data are stored in separated fields, connected as external data source to the main.
This is very efficient because our system is upgraded on the run. Simply by replacing the main field, all changes are applied to users. But it means that all users (30 - 35) has open 20 databases (hidden).
We are using FMSA 10 (or 11) on Win 2003 server, on double dual core processor. Question is: Can this structure reduce the performance of fmsa? Because I see sometimes the service fmsa consume 80% of CPU and then, there is no response from the server.