[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 the 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 the Optimizer file. Next time when you query the same table, QODBC will request differential records that are added, modified, and deleted from QuickBooks and will sync it to the Optimizer file.
This way QODBC will have to only get the differential records instead of the 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 the 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 a 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 the below steps for removing/deleting the 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
For QODBC POS - Start >> All Programs >> QODBC Driver for use with QuickBooks POS >> Configure QODBC POS Data Source
For QODBC Online - Start >> All Programs >> QODBC Driver for QuickBooks Online >> Configure QODBC Online Data Source
Go To the "System DSN" tab, select "QuickBooks Data" DSN & click "Configure".
For QODBC POS select "QuickBooks POS Data"
For QODBC Online select "QuickBooks Online Data"
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.
QODBC Desktop: The optimizer file can be found at "%appdata%\QODBC Driver for QuickBooks\Optimizer"
QODBC POS: The optimizer file can be found at "%appdata%\QODBC Driver for QuickBooks POS\Optimizer"
QODBC Online: The optimizer file can be found at "%appdata%\QODBC Driver for QuickBooks Online\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