I’m using Delphi to develop my custom DA application server. Over the years, my DA service grew big and has hundreds of Data Tables and Commands. I understand, from performance perspective, there might not be to much penalty to pay, since when a service just finds the Data Table to serve among a few hundreds of names. My issue is that this starts to be a bit hard to maintain and manage. Splitting the tables in more than one DA services I guess is one option, but this requires switching between ServiceName in the TRORemoteService component on the client side when a form will require Data Tables from 2 or 3 DA services.
Is there a best practice for this I’m trying to do? Am I missing something that I should know by now, after using DA for years, to achieve this?
P.S. In my Database I use schemas for logical separation of tables and procedures.