We are creating new Appian tables in a schema with a large amount of data (approximately 45 million) from Oracle DB. We are experiencing significant delays when connecting to the data source and configuring the record type. After selecting the data source, it takes approximately 4 minutes to load all of the tables in the schema, which I believe is unnecessary. We occasionally get a timeout error. Both the search and browse features work the same when selecting the source.
Even if we can select the table and sync it, it takes a long time to switch between the record type tabs during development. Every button click takes some time.
I appreciate any suggestions you may have.
Discussion posts and replies are publicly visible
It is a best practice to create a separate schema for each Application ...
Agreed. But its not possible for us as we have other systems using the same schemas and tables.
What I mean is that you could have an app-specific schema and the other schema just to fetch secondary data.
But to understand these long evaluation times, we would need more info. Number of tables, type of Appian environment (cloud/on-prem), VPN, internet connection, firewalls, Oracle DB location and setup, and probably a ton more....