What is a cache
Cache (also known as connection cache or database cache) is a
mechanism employed in PowerServer to store and manage database
connection information. It is responsible for maintaining the necessary
details required to connect to the database server, including user ID,
password, database connection string, and other essential information.
PowerServer leverages the cache to establish connections with the
database.
For each transaction object used in the application, a
corresponding cache must be mapped with in order to to set up the
database connection during runtime. This mapping can be accomplished
through either the project painter in IDE (read
more) or through application scripts (read
more).
The cache itself can be created and managed either within the
project painter in IDE (read
more) or through the PowerServer config file (read more).
Typically, it is created in the project painter as it is used during the
project build process within the IDE. During this process, the IDE
connects to the target database and generates C# models. Once the build
process is complete, the cache is deployed to PowerServer and used at
runtime to establish connections with the database when the application
is executed.