Geek Answers Handbook

Delphi 2010 Datasnap - Design Request

I am exploring porting a Delphi application with a thick SQL client to Multi Tier thin clients and considering using Datasnap in Delphi 2010. I have been working on White Paper written by Bob Swart and have expanded this further.

My main question is that I want to make the server side efficient in terms of connections and SQL queries due to the simultaneous launch of several queries and remaining open for polling data, can someone point me in the direction for guidance? on how to design a Datasnap application for the real world, as the demo does not go into the details.

Thanks Matt

+5
source share
1

:

  • (Mid-Server) (stateful vs stateless)

  • (Mid-Server) . ( , , - - GUID, - , , ).

  • (/ ) . (, Id, FK Category. ).

  • (Mid-Server/RDBMS) , . , ( ) .

  • (Mid-Server/RDBMS) , / . Mid-Server - RDBMS - , /CPU/IO .

  • (Mid-Server/RDBMS) - Mid-Server, . . , 2000 ( , SP), Mid-Server 1500 2000 , SP, GREAT . 500 , . , 1500. 500 .

  • (Mid-Server/RDBMS) , , , .

  • (Mid-Server/DataSnap). . OnBeforeUpdateRecord , .

  • (Mid-Server/DataSnap). , ClientDataset ? , ...: -)

    Cds_New.Data: = Cds_Updated.Delta;

+1

More articles:


All Articles