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:
This prevents blocking of reads during a full extract.
Please apply the indexing script found at https://dl.eveoh.nl/erdb322_indexes.sql
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