[QODBC-Desktop] How to Remove Optimizer file
Posted by Rajendra Dewani (QODBC Support) on 08 November 2013 08:35 AM
How to Remove Optimizer file
What is Optimizer file?
When you turn on the Optimizer, QODBC will bring some data to a local cache file (the optimizer file) to increase retrieval performance for queries.
When you access any table, QODBC will gather data from QuickBooks and will store it in Optimizer file. Next time when you query the same table, QODBC will request differential records which are added, modified and deleted from QuickBooks and will sync it to Optimizer file.
This way QODBC will have to only get the differential records instead of entire data set from QuickBooks. As a result, you will notice performance gain when compared to working without Optimizer.
To know more about Optimizer Click here
When should I remove/delete the Optimizer file?
You should delete optimizer file whenever you notice that your optimizer file is not updating (last modified date has not changed even though QuickBooks has updated and using QODBC regularly) and/or the QODBC logs has optimizer file corrupted related messages. Please refer below mentioned link for:
What happens if I continue to use corrupted Optimizer file?
If you keep using the corrupted file, QODBC will not be able to update the optimizer file; as a result, you may notice slowness while retrieving data from QuickBooks.
QODBC will have to get all the data whenever you perform any query on a table.
Follow below steps for removing/deleting optimizer file.
To delete the optimizer file. Please close/disconnect all the applications connected to QODBC
Remove Optimizer file from: Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source
Go To "System DSN" Tab, Select "QuickBooks Data" DSN & click "Configure".
Switch to Optimizer tab
Click Reset Optimizer File(s)
Click Yes to delete all the Optimizer files.
Please note: All the Optimizer files under the Optimizer Database folder will be removed. If you wish to delete a single company file's optimizer.
Optimizer file can be found at "%appdata%\QODBC Driver for QuickBooks\Optimizer"
For Example: C:\Users\Dewani\AppData\Roaming\QODBC Driver for QuickBooks\Optimizer
Please refer How to Find Optimizer File/Where is Optimizer File Located and delete the file manually.
Tags: Reset Optimizer File, Remove Cache, Rest Optimizer, Rest Cache