After you have upgraded to version 9, you may experience slowness while loging into SOHODOX or while browsing through documents etc. There may be many reasons for this but we have found that the below solution has worked in many cases.

Solution :

Step 1: Set auto_close as off in the SQL Server based MainDB. Follow the steps below to do this...

1. Back up the SOHODOX Databases after making sure SOHODOX is not being accessed from any of your network machine.
2. Now, on the machine where MS SQL Server is installed, launch the SQL Command Line. You can open the SQL Command Line Window by pressing 'Windows button + R' from your Key Board.
   
3. Once the RUN dialog appears, type in sqlcmd.exe and hit Enter. The SQL Command Line window will launch.
4. At the Cursor type...
   alter database MainDB_sdx set auto_close off
   
5. Press Enter. The Cursor will now move to 2nd Row, now type GO and again press Enter.
6. If the Cursor returns to the next line without hitting any error, then the SQL Server based MainDB_sdx file is updated for optimum performance.
   
7. The same process will have to be performed on the MainDB_cache file as well.
8. At the Cursor type...
   alter database MainDB_sdx_cache set auto_close off
9. Press Enter. Now type GO and press Enter.
   
10. Once, the Cursor returns to the next line close the SQL Command Line Window.
11. Restart the ITAZ SOHODOX Server Service for the changes to take effect by following the below mentioned steps.
1. Go to Control Panel >> Administrative Tools >> Services panel.
2. Now, under Services search for ITAZ Sohodox Server service.
3. Right-Click on this service and restart the same.

Now start SOHODOX you will find it is loading much faster.