Hello, I am considering converting a system from a proprietary implementation of FoxPro database and the Microsoft Jet access engine to MaxDB.
I was hoping someone could give me some advice on how our current structure could be ported to MaxDB. Currently, whenever we add a new client my system creates a new filepath on the database server and creates all of the appropriate client specific tables in that directory and then makes an entry in our master client table indicating the client general information and the filepath to the client's directory. The client specific directory contains approximately 40 different tables depending on which of our services the client is using. What I am having difficulty with is how to map this process to MaxDB. As best as i can determine I would have to either: 1. Create a different database for each client 2. Create all of the tables for all of the clients in the same master database and prefix the table name with some client specific code. 3. Have only one of each kind of table and a key field that links each entry to which group the entry belongs. 1. Seems like it would require a DBA to do some work for each new client. 2. This would currently mean 16,000 tables in one database for my existing 400 clients. 3. I have to wonder what the performance hit would be considering instead of looking for all of the transactions from 1/1/2004-12/31/2004 for a certain plan participant from a table of one million records it would be searching for them in a table of 50 million records. My main reason for wanting to switch how we currently do it is to allow for a replication slave in an off site location that would be synchronized with our current database up to the minute instead of just backups that are done a couple of times a day. As for the activity on the tables. We have about 10 people who access the tables to post received checks and answer questions from clients and participants. We have another 5 who perform data entry. in addition we have an IVR system that takes calls on several phone lines that access the database and we have a web interface that allows participants to examine account information. Generally at any one time approximately 50-100 people can be executing some sort of request against the database server. I do not have a high insert or update volume. Thanks for any help. Darrell -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
