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
|
|
One-off query speed improvements? |
Author |
Message |
|
Posted : 2009-01-06 07:44:16 |
Hello. I am currently using the trial version of the QODBC driver to determine whether or not it meets our needs. We don't use QuickBooks much, but we have recently acquired new business that has brought along QuickBooks applications with years of data. Our simple goal is to rip everything out of QuickBooks and put it into SQL Server.
So, the point is that we won't be using QuickBooks or QODBC often, or for repetative tasks. Instead, we will be using it for a major export of QuickBooks data.
With that said, some of the QuickBooks tables are fairly large, with about 100,000 records each. The QODBC driver takes a very long time to get everything out of those tables (up to a couple of hours on one of our not-so-fast machines). I'm wondering if there's any way to speed this up.
Is there anything about using the trial version that's throttled compared to the registered version? Is there any reason to expect that the registered version will run faster?
I've followed the advice on these forums to set the Optimizer settings. However, that when I re-open the settings, all the settings revert to default. Do settings only get saved for the Registered version? Even so, since I won't be running any queries frequently (ideally only once) the optimizer doesn't help me much.
So, I'm just hoping to find out if a couple of hours for 100,000 rows is normal, or if I've done something wrong. Or, if I get the Registered version will it just be a lot faster?
Thanks. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-06 12:20:40 |
|
|
|
|