Now to do a financial system to the customer, to prepare a database is a zhang set on a server, each account has about three user, that is the highest when there will be 100 sets of zhang * 3 user/each account, as many as 300 concurrent, developed into 2 is feasible, I only had two layers of development, if can use three layers of the same application service program can handle up to 100 database? Have any good solutions, please give advice or comments

CodePudding user response:

A database, the database and is related to the maximum number of connections allowed

CodePudding user response:

Use DATASNAP, establish only use a database, the difference between different sets of account:
Table name prefix or suffix, or in the database of each table to join account classification to distinguish,
But in the use of the currently popular access billing software, a set of account, a database approach is not desirable, you would not make dozens of sets of account set up dozens of connection,
I are exploring to establish more than one way to connect to the database, the building Lord if you have any Suggestions can be discussed?

CodePudding user response:

Currently ufida, kingdee account set is much more database, if placed in a database, the table name to distinguish between processing, is made of three layer multiple database can be a great trouble to deal with, also please your comments

CodePudding user response:

Are exploring datasnap using multiple databases, namely dynamic conversion database operation, so that you can implement set of accounts using a separate database,

CodePudding user response:

The individual feels this kind of financial system and there is no how many concurrent use at ordinary times, mainly query is given priority to, and only check once a mouse, which come of concurrent?
So long as the program quality pass.

CodePudding user response:

reference 5 floor tcmakebest reply:

the individual feels this kind of financial system and there is no how many concurrent use at ordinary times, mainly query is given priority to, and only check once a mouse, which come of concurrent?
So long as the program quality pass.

If it is a group enterprise, or a city, the whole medical system, there may be dozens or hundreds of computers will fill the documents and queries, on the second floor of my main worry now database can directly links to 150 clients

CodePudding user response:

reference 4 floor lyhoo163 response:

are exploring datasnap using multiple databases, namely dynamic conversion database operation, so that you can implement set of accounts using a separate database,

Thank you, I'm going to use MS SQL2005 database or 2008, adopt more sets of books on a table, can field to distinguish between different account set of records, but there is no want to good what to use three layer components to handle RemObjects or DataSnap, so long as can handle within 200 stable and efficient access is ok at the same time

CodePudding user response:

Do it, you can learn each other, I also want to do a set of accounting accounting system?