By default, the Scientia Syllabus Plus ERDB is not really optimised for high performance. Most SQL indexes are missing from the database. Also, older ERDB versions require some fixes and additions to overcome bugs and missing data. Eveoh provides various T-SQL scripts to improve the ERDB. The indexing scripts should have no negative impact on other applications. Several indexes are added to improve read performance. Write performance will be lower, but usually the ScheduledExtract.exe process is the only process to write to the ERDB.

Scheduled Extract settings

Please make sure the scheduled extract is running in transactional mode (/T command-line switch). This should be the case for full and incremental extracts (even though Scientia documentation says incremental extracts run in a transaction by default, which is not true).

Please make sure the SQL Server database is running in read committed snapshot mode, by running the following command on the database:

ALTER DATABASE [RDBDatabaseName] SET READ_COMMITTED_SNAPSHOT ON

This prevents blocking of reads during a full extract.

Version 3.11

Please apply the indexing script found at https://dl.eveoh.nl/erdb322_indexes.sql

WRB indexes

If you are showing Web Room Booking timetables to your users, please index the appropriate column, containing the username, in the ACTIVITY table. By default, this would be usertext2. An indexing script can be found here: https://dl.eveoh.nl/erdb322_wrb_index.sql

  • No labels