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
|
|
Upgraded Hardware to newer P4 3.2,, QODBC running slower |
Author |
Message |
|
Posted : 2006-05-07 03:06:33 |
Dear Tom,
This is Rodney again,.
I just upgraded my hardware to the newer Pentium 4 3.2 Mhz with 512 ddr400. My problem is , the Qodbc is running much slower despite the higher speed of the new P4 . Compared with my old computer, it is running 4x slower. I verified this by simultaneously executing the two computers (old & new) using the same set of data.
When I upgraded the hardware, i use a thrid party software to I copy an exact duplicate of whatever is inside my old hard disk including the operating system to the new hard disk,.
Do I need to do something like deactivating and activating Qodbc? Should I uninstall and reinstall QODBC?
By the way, my prior hardware was an AMD Athlom 900 Mhz. All other software or application I used are running much much faster using the new P4 except for Qodbc- instead of running faster it is executing much slower.
Can you help me on this one again?
Thanks and besr regards Rodney |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-07 15:08:44 |
The correct procedure would have been to deactivate QODBC on the old hard drive before copying the disk image to the new computer and activate the new hardware platform. And yes, I would re-install QODBC, but as far as the Windows OS is concerned, by the sounds of things I'm not too sure that it has been properly reconfigured for the new processor envirnoment. Disk Imaging on the same hardware platform works well, but I'm not to sure how succesful you were here if QODBC is running 4x slower. Generally speaking the Windows OS needs to be installed on it's hardware platform. |
|
|
|
|
Posted : 2006-05-07 23:54:09 |
Dear Tom,
Thanks again for your insight.
There seems to be no problem with the disk image operating system/hard disk. when I installed it to the new computer. The OS reconfigured itself after detecting the change of hardware environment. Of course, I still have to reconfigured some of the setting manually by installing the new hardware device installation softwares.
I tested all the application I have and all are runnig smoothly and faster as expected due to the higher processor speed/power. It is only with Qodbc that is affected by the hardware change. It is running without a glitch except that it is slower by 4x.
I have already uninstalled, reinstalled, and reactivated Qodbc without any effect on the performance-slower.
My option right now is to maybe start everything from scratch. I'll reformat my hard disk, install again the OS and every software application including Qodbc. Do you think this will help resolve the speed issue?
Thanks again Tom.
with best regards, Rodney |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-08 08:12:24 |
I'm not sure as you haven't provided a sample SQL statement that runs slower. With the release of QODBC v6.00.00.155 we had to do a little more checking for deleted transactions and payments so tables that reference a open balance now run slower. Most users tend to use queries like:
SELECT * from Customer
which will run slowly as QODBC has to display the correct current open balance for each customer, while this will run much faster:
SELECT "Name","LastName","FirstName","BillAddressAddr1", "BillAddressAddr2","BillAddressCity", "BillAddressState","BillAddressPostalcode" from Customer |
|
|
|
|
Posted : 2006-05-08 11:38:47 |
Dear Tom, On the software or application side of Qodbc - everything are the same/identical between the old and new computer . Their only difference is on the hardware side. The new computer is P4 3.2 mhz 512 PC3200, SATA HD, under XP sp2 Hyper threading, whereas the old one is Amd Athlom 900mHz, 512 PC133, IDE HD, under XP sp1 Theoretically, the new computer should be able to execute my application 3.5X faster or better than the old computer.
Already reformatted and reinstalled everything on the new computer and only Qodbc is still running slower.
Any suggestion that I should do to improve the speed of Qodbc on the configuration side?
Best regards,
Rodney |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-08 12:58:52 |
I understand the hardware changes, but you haven't said what QODBC revision is being used, how the optimizer is configured, with what version of QuickBooks and what SQL query statement is running slower? |
|
|
|
|
Posted : 2006-05-08 13:46:50 |
Dear Tom,
I'm using the latest version of Qodbc 6.00.00.155, Quickbook 2005 Pro, using Access 2000 via link table - unoptimized since I need to get the latest or up to date information. I always retrieve / extract the most updated "ReceivePaymentToDeposit" records from QB first thing in the morning to prepare the necessary check deposits for the day.
As mentioned on my prior message, the application/software side on both computers are exactly the same or identical, both running the same Qodbc version, the same sql statements, same all the way to the last period. The only difference on the software side is the operating system. The new one under XP pro sp2 hyper threading enabled, the old one under XP pro sp1.
Thanks again Tom.
Best regards rodney |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-08 14:19:50 |
I would be inclined to run a test SQL statement using VB Demo outside of Microsoft Access to verify the real speed differences. A Hyper threading processor is not going to help QODBC in any way. |
|
|
|
|
Posted : 2006-05-08 14:35:53 |
Dear Tom,
Ok, Will do exactly as you suggested-use VB demo to rule out everything. Will do the test tonight, will inform you the result.
Thanks
Best regards rodney |
|
|
|
|
Posted : 2006-05-08 23:41:57 |
Dear Tom,
Found the culprit causing the slow down of Qodbc. It was the window ODBC Driver Manager wherein the trace and Visual Studio Analyzer function was turn on thus slowing the whole process. I have no idea how it was turn on, my guess is - it must be the default setting when I reinstalled the operating system XP.
Nevertheless, thank you again for your effort and help.
With warmest regards, rodney |
|
|
|
|