Knowledgebase
[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:

How to verify if Optimizer file corrupted or not 

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

(0 vote(s))
Helpful
Not helpful

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