This article applies to InventoryControl v6 & v7, MobileAsset v6 & v7, WaspTime v6 & v7.
Most SQL database latency issues are due to network speed and/or server speed. However, if a particular database has been in use for a while, with quite a bit of data, it may have built up data that slows down how SQL is able to retrieve information. The following linked scripts truncate logs, shrink, and reindex the database.
- Back up the database.
- On the database server, download and save the zip file appropriate to your application and version of SQL server. Extract the zip file, then run the Update.bat file.
- Note 1: The zip file must be extracted first. If Update.bat is run from within the zip file, it will not work.
- Note 2: Enterprise edition users who are not using a SQL instance called WASPDBEXPRESS and/or are not using Wasp's usual sa account password: Execute the included script file (with .SQL extension) from within SQL Server Management Studio.
- Note 3: MobileAsset Enterprise edition users with additional database(s): You will need to edit the script file, replacing WaspTrackAsset with the additional database name(s).
| SQL 2005 & SQL 2008 | SQL 2012 | |
| InventoryControl | ImproveSlowDb-IC-sql2005-2008 | ImproveSlowDb-IC-sql2012 |
| MobileAsset | ImproveSlowDb-MA-sql2005-2008 | ImproveSlowDb-MA-sql2012 |
| WaspTime | ImproveSlowDb-WT-sql2005-2008 | ImproveSlowDb-WT-sql2012 |