Just after some clarity.
The ApiServer web.config has a connection direct to the DB and a connection to AppServer.
What kind of "stuff" goes over each? i.e.
- Is the DB connection for Updates only or for user interactions (searches, requests, modifications, etc)?
- Is the AppServer for all user interactions with the portal or just searching (with its built in indexing)?
- Do the different ApiServer portals use DB connections differently?
- The AppServer has a DB connection, as expected, and connections to any Data Archiving DBs for use in the portal - assumption this remains the path in ApiServer for Data Archiving retrieval?
Tracing this stuff isn't fun if we don't know what components actually do and how they interact with the data.