Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Is anyone out there having any performance issues with the QuickBooks Connector? One of our clients is reporting that it takes 90 seconds per order to export. We don't have any other clients using this tool, so I don't know if that's normal... |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 7/14/2004(UTC)
Posts: 254
|
This is abnormally slow. We dont use the QB connector but our software also uses the Intuit SDK which lets us read via XML. It is inherently slow and a memmory hog say compared with an ODBC driver. That said, we can read ALL the journal entries and the sales transactions from the QB sample file "Larrys Landscaping" and build SSAS cubes in SQL server in around 6 mins, so I'd suspect something else is creating a bottleneck. Not much help but some kind of benchmark for you. <SPAN style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: black; FONT-SIZE: 10pt"><SPAN style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-fareast-language: EN-AU">John Power <FONT style="COLOR: #008b8b">CEO - BizTools www.biztoolsanalytics.com</FONT>
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Each order should only take a few seconds. Is this an Enterprise version running remotely that might need to synch data or something?
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Originally Posted by: "Marcus"  Is this an Enterprise version running remotely that might need to synch data or something? Yes, this is the Enterprise version. A desktop computer, on the same LAN as the QB Enterprise server, is running the QB connector. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
|
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 7/14/2004(UTC)
Posts: 254
|
If possible, as a test, can you run everything on the one machine and eliminate the network? Also, is QB closed or are people actively using it at the same time? <SPAN style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: black; FONT-SIZE: 10pt"><SPAN style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-fareast-language: EN-AU">John Power <FONT style="COLOR: #008b8b">CEO - BizTools www.biztoolsanalytics.com</FONT>
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.