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
|
|
use the optimizer file .OPT on another PC |
Author |
Message |
|
Posted : 2006-06-16 02:49:21 |
I sent a query on my Quickbooks file and it took to the optimizer roughly 25 minutes until I got the result. I sent again a query, and I get this time the result within few seconds. Fine.
My question is : on another PC there is a copy of my Quickbooks file which is exactly the same. What happen if I copy/paste my .OPT file onto the other PC. Will it work quickly ? I would like to avoid the other user to spend again 25 minutes building the optimizer file.
Is it possible ?
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-06-16 09:36:07 |
Yes, providing QODBC is not running at the time (on both computers) and the QuickBooks company file are the same, for example the company file is a on network drive used by both PCs. |
|
|
|
Gary |
|
Group | : Members |
Posts | : 30 |
Joined | : 2006-04-08 |
|
Profile |
|
Posted : 2006-07-13 02:46:24 |
QB not running, I copied the opt file to another PC then ran my Access query. My company file is on the network and I have the latest version of QODBC . The other PC Optimized the table again which took many, many minutes. Am running XP. Is there a process that needs to be shut down first? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-13 08:29:59 |
The latest version of QODBC does do some re-organising of the opt file structure on older versions of the opt file as well as the optimization of ReceivePayment and ReceivePaymentLine was changed to never use iterators to avoid the SDK bug. |
|
|
|
|
Posted : 2006-07-13 17:37:40 |
However,
I was working on V5 once, and although the queries were a bit slow, I was not bothered by re-organizing opt file wich takes many minutes. All in one, I would prefer not use the optimizer.
The problem is that I tried to turn off the optimizer in the settings, and despite, the optimizer always activate itself. I cannot prevent the opt updating.
Fustrating. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-13 20:23:22 |
Most people don't realize that many front-ends, like MS Access for example, store the first connection settings so if I link QODBC tables in MS Access and then switch off optimization, when I reopen my Access .mdb, the stored connection setting would re-run the optimizer again despite switching it off. You can also run in v5 mode by using the UNOPTIMIZED tag.
To temporarily bypass your optimizer settings and extract the latest information you can add the unoptimized tag after the table name like this to your queries:
select * from InvoiceLine unoptimized where TxnDate >= {d'2006-03-06'}
See: How do I setup the QODBC Optimizer? Where are the Optimizer options? for more. |
|
|
|
|