https://answers.axonivy.com/tags/systemdb/?type=rss&user=SupportIvyTeamquestions tagged <span class="tag">systemdb</span>enMon, 04 Feb 2019 10:43:40 -0500https://answers.axonivy.com/questions/3654/huge-mysql-mariadb-system-database-has-slow-response-time<p>I've got so far some ivy engines running with mysql and mariadb as system database. The databases are huge, with about 10'000'000 tasks. With more and more tasks the responding time will be slower. The more tasks in the database, the worse the response times. Is there anything I can do to optimize this?</p>SupportIvyTeamMon, 04 Feb 2019 10:43:40 -0500https://answers.axonivy.com/questions/3654/huge-mysql-mariadb-system-database-has-slow-response-timemysqlmariadbsystemdbdatabasehttps://answers.axonivy.com/questions/3284/where-to-get-an-entity-relation-diagram-erd-of-the-axon-ivy-system-db<p>Is there any schema documentation available that show the relations of the tables in the Axon.ivy system database?</p>SupportIvyTeamThu, 24 May 2018 06:25:53 -0400https://answers.axonivy.com/questions/3284/where-to-get-an-entity-relation-diagram-erd-of-the-axon-ivy-system-dbsystemdbhttps://answers.axonivy.com/questions/2007/how-to-improve-performance-of-mssql-system-database-with-jtds-driver-many-temporary-files<p>If I use an Microsoft SQL Server as System Database and access it with the jTDS driver. Then I have many temporary files (jdtsXYZ.tmp) stored with clob and blob data in the temp folder. How can I avoid that they are created? Because it is obvious that the performance of storing such files is not as good as if the data is only held in memory.</p>SupportIvyTeamWed, 07 Sep 2016 09:25:31 -0400https://answers.axonivy.com/questions/2007/how-to-improve-performance-of-mssql-system-database-with-jtds-driver-many-temporary-filessystemdbmssqlhttps://answers.axonivy.com/questions/1768/sql-select-all-cases-that-belong-to-a-specific-process-model-version<p>How would a SQL select statement look like, that returns all Cases that run in a specific Process Model Version?</p>SupportIvyTeamWed, 11 May 2016 10:43:21 -0400https://answers.axonivy.com/questions/1768/sql-select-all-cases-that-belong-to-a-specific-process-model-versioncasepmvsystemdbsqlhttps://answers.axonivy.com/questions/1164/create-system-db-on-db-server-without-engineconfigurationui<p>With the AxonIvyEngineConfigurationUI I can create a MS-SQL DB on my developer workstation. In production I do not have enough rights to create a System-DB on the SQL Server. So our operations team must create the empty System-DB without Java on the DB-Server. Is there a dump that can be used to for this task?</p>SupportIvyTeamTue, 17 Feb 2015 14:08:17 -0500https://answers.axonivy.com/questions/1164/create-system-db-on-db-server-without-engineconfigurationuiconfigurationsystemdb