I'm completely new to Datasnap.
I surfed the net and found a few articles. I have a few questions. I
have to rewrite a ERP application. Max concurrent users will not
exceed 50. Database is Firebird. The current version is a fat client.
Database on the server and all queries / business logic / GUI in
the .exe. So I was wondering if it would be a good idea to seperate
things into layers, so I ended up looking at Datasnap. However I'm
wondering the following things :
1) Is Datasnap the way to go in the new design or is a fat client a
better idea ?
2) Is Datasnap using 1 connection to the database, or multiple ? What
if 10, 20, 30, 40.... users are connecting, is the application server
adding extra connections automatically when the workload is getting
higher.
3) Workload could be high, what if user A is waiting for a large query
to execute, what about user B who needs data ? He has to wait for the
task of user A to complete ?
4) Is it stable ? Because the user needs a application that won't
disconnect suddenly, or things like that.
Maybe my questions are very basic, that's why I'm wondering if there
are good tutorials available who teach the basics to the advanced...
Many thanks in advance,
N.