Developer Documentation Library > Interviewer - Server > Architecture > Interview Service tier > Project Cache
 
Project Cache
To produce the best results in terms of speed and productivity, UNICOM Intelligence Interviewer holds recently used projects in memory and maintains recently used SQL connections for a certain amount of time even if there is no activity on the project. This collection of projects and SQL connections is known as the Project Cache.
The Project Cache contains a projects collection with one object for each project. The case data connection and quota factory using the MDM superversion are saved in the cache at the Project level. Each Project also contains a ProjectVersions collection with a ProjectVersion for each version of the questionnaire (.mdd) file that has been loaded. The specific MDM version and prepared interview script for a version are saved in the Project Cache at the ProjectVersion level. See Project Cache component for more information.
Projects are removed from the Project Cache once they have been inactive for 12 hours, whereas SQL connections to the sample database are released after one hour. (The reason for this difference is that it takes less time and resources to reconnect to a SQL Server database than to reload all files belonging to a project.) Messages are written to the IVW log file indicating that objects were uncached or SQL connections were disconnected.
The inactivity times are set in these registry keys:
ProjectInactivityTimeout
DisconnectTimeout.
See also
Interview Service tier