|
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
|
|
| Slow response times w/ QODBC 8.0 & QBES 8.0 |
| Author |
Message |
|
|
| Posted : 2008-01-01 03:11:33 |
I initially started development in MS Access 2003 with QBES 7.0 & QODBC 7.0 on MS XP platform . It is a relatively simple setup of reading from the Item Table and SalesOrderLine Table to create a custome label and form. With adding filters my responses were slightly sluggish so I made Create Table Queries to give me a local file to work with and speed things up a little. This seemed to be working pretty well. Then...
I got a new development machine that is Vista platform & MS Access 2007 (still developing in 2000-2003 compatibility). In the same general time frame the client was upgraded to QBES 8.0. So I converted my QB file to version 8.0 and am now using QODBC 8.0 (latest release). The same make table query took 25 minutes to come back.
As a result, I have switched to trying to work with QB SDK, but I'm not ready to throw in the towel on QODBC. It is an Access platform and should be the easiest route to go and it is included with QBES.
Do you have any suggestions that may help me out here? |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-01-04 10:10:27 |
When you installed QODBC v8, the optimizer options were changed back to the defaults that are not really suitable for use with MS Access. The start of every query is the default optimizer setting. The start of every new connection (with "Load Updated Data" first) should really be used with MS Access. The optimized data is updated upon opening a table in MS Access and left unupdated until the next new connection occurs again or you force an update.
See: How do I setup the QODBC Optimizer? Where are the Optimizer options? for more. |
|
|
|
|
|
| Posted : 2008-01-07 11:50:10 |
| I'm a newbie at this but I'm very impressed with the QODBC products! I am a property manager with many QB 2005 files representing my individual customers (so I can keep monies separate and create bal sheets, etc). I needed a way to extract some data into excel for a pivot table application, to create a simple to read income-expense table. I'm using MSQuery and ver 8.0 QODBC. This is working well, interogating Check, Deposit and Bill Payment tables. I did notice performance was a lot slower when the QB file was open in multi user mode as opposed to single user mode. I'm using defaults for the optimizer and all other driver settings. I've also experimented with QReportBuilder and very impressed by the product as well, very fast and easy to use. I needed a way to get the details of Bills out of QB's and no standard report has this info on it (just the top level memo fileds). I created a simple expenseline based report and got just what I wanted. Will be buying a copy. Can I get a discount for already owning a QODBC user license? |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-01-08 12:05:57 |
| Please contact the FLEXquarters.com LLC sales office directly on: 800-932-6448 or +1 248-360-7842 regarding pricing questions on QReportBuilder. |
|
|
|
|