You can achieve better performance in a SQL repository-based application by pre-loading the caches. Note that the improvement in performance from pre-loading caches comes at the expense of slower application startups. You can configure the SQL repository to automatically save and restore its caches, or you can load the caches manually by using the startSQLRepository script with an appropriate XML file. It is probably a good practice to put cache-loading tags in a separate XML file with the same name as your repository definition file and rely on XML file combination to invoke the queries.
