[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 store it in the Optimizer file. Next time you query the same table, QODBC will request differential records that are added, modified, and deleted from QuickBooks and will sync them 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 compared to working without Optimizer.

To learn 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 (the last modified date has not changed even though QuickBooks has updated and using QODBC regularly). The QODBC logs have optimizer file corrupted-related messages. Please refer below-mentioned link for:

How to verify if the Optimizer file is corrupted or not 

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 query 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.

Remove Optimizer file from Start >> All Programs >> QODBC Driver for QuickBooks >> Configure 32-Bit QODBC Driver.



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 the 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 to 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

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).