|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Optimizer suddenly rebuilds each time a query is executed |
| Author |
Message |
|
|
| Posted : 2007-09-16 01:17:30 |
| Hello,
We are using a FileMaker / Quickbooks / QODBC solution to grab new orders from an eCommerce solution and write them to the Quickbooks company file.
About two weeks ago, running the process of grabbing a new order from the eCommerce solution and writing it to the Quickbooks backend started taking a long time. As part of this process data from Quicbooks is queried. For some reason, every time this process is run, the entire optimizer file rebuilds itself. This is definitely new behavior and I'm frustrated because I don't know what to tell the client (my folks) in terms of why this just started "happening."
I can rebuild the solution to severely restrict the Quickbooks queries I need to do (maybe by only looking at "recent" entries in various tables) but I don't want them to have to pay me more money if the original functionality can be restored.
Do you have any idea why the optimizer file needs to rebuild itself now on each query? Our optimizer selection is "update at the start of each query" which--as I understand it--should *not* rebuild the entire optimizer file each time; rather, it should simply update the cached data with changes.
Thanks. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-09-16 18:32:09 |
The start of every query is the default QODBC optimizer setting using the most current data. If your query needs require the latest up to the minute data and speed is not the primary focus use this default setting. Please keep in mind that the QODBC Optimizer is local to your computer only, so when other users change things in QuickBooks how does QODBC know? Well, by default the optimizer will update new and changed entries in a table from QuickBooks first and then execute the query against the local optimized table. This is faster than reading everything out of QuickBooks every time, especially the more data you have
Please review your clients QODBC optimizer settings, the default setting isn't the best option. See: How do I setup the QODBC Optimizer? Where are the Optimizer options? |
|
|
|
|
|
| Posted : 2007-09-16 23:58:45 |
| Yes, thank you.
I've already read the other topic. Here's the issue that I'm asking assistance with:
Why, if the optimizer is supposed to just update changed and new records at the start of each query, is it *rebuilding* the entire optimizer file for every single table at the start of each query?
The assumption underlying my question is that an "update" is different (and far less time consuming) than a "rebuild" or a "reload" of the data.
Secondly, why would the behavior have suddenly changed? The optimizer setting was and is "at the start of each query" and it now launches a 30-minute "reload"/"rebuild" instead of a ~5 minute "update"?
We are running 7.00.00.194 (which I know isn't the most recent update . . .)
Thanks. |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-09-18 15:26:46 |
Please update to QODBC v7.10.00.231 (or higher) as I can't fault find 37 revisions back and advise. See: How can I get the latest version of QODBC?
The only reason for the behavour is if the user is different or you are using a Sample company file. The default location for the optimized file is %userprofile%\QODBC Driver for QuickBooks\Optimizer for the Windows login account name under the Documents and Settings folder. |
|
|
|
|