Announcement

#2 · 05-06-04, 12:53 PM

Speed of Synchronization

Hi Rich,

With each order Miva Synchro adds to QuickBooks, it first needs to query
QuickBooks to see if that order number already exists. If you have a high
volume of orders in QuickBooks already, this process can take a long time.

Jimmy
Miva Support Engineer
Please REPLY to keep message history.

Miva Corporation
A FindWhat Company
NASDAQ: FWHT
(858) 490-2570
Mon. - Fri., 9am - 5pm (PT)

***********************************
Do you have questions? We have answers!
Check out our FAQ at:
<A HREF ="http://www.miva.com/support/faqs">http://www.miva.com/support/faqs</A>
***********************************
NEW! Miva Service Club
Starting at only $149/yr.
Visit www.miva.com/support for details.
***********************************

-----Original Message-----
From: Wallace, Richard L CIV [mailto:[email protected]]
Sent: Wednesday, May 05, 2004 8:28 AM
To: [email protected]
Subject: [scu] Speed of Synchronization
Importance: High

All,

Synchronizing orders (evn just 1 or 2) with QuickBooks 2004 Pro data
file was extremely slow. In an attempt to speed it up, I condensed the
QuickBooks file to keep only the data since 1JAN2002. Synchronization
was faster but still SLOW; making it very annoying.

??? Can anyone explain how Miva Synchro does what it does? i.e. what is
it doing/searching through in QB? Is it going through every single QB
invoice for each Miva order? ...etc. If I (We) understand how it is
doing what it does, than maybe we can optimize it's performance.

Thanks,
Rich

#3 · 05-07-04, 04:26 AM

Speed of Synchronization

------_=_NextPart_001_01C4342E.76141109
Content-Type: text/plain;
charset="UTF-8"
Content-Transfer-Encoding: base64

MSkgV2hhdCBoYXBwZW5zIGlmIHRoZSBNaXZhIG9yZGVyIG51bW JlciBhbHJlYWR5IGV4aXN0cyBp
biBRQj8gRG9lcyB0aGUNClN5bmNocm8gcHJvY2VzcyBhYm9ydC B3aXRoIGVycm9yPyAuLi5oYW5n
LCBldGM/DQogDQoyKSBJcyBTeW5jaHJvIHRlbGxpbmcgUUIgdG8gc2Vhcm NoIHRocm91Z2ggYWxs
IG9mIHRoZSBvcmRlcnMsIG9yIGRvZXMgUUINCmRvIGl0IGFueX dheSwgd2hlbmV2ZXIgYW4gb3Jk
ZXIgaXMgYWRkZWQ/IElzIHRoZXJlIGFueSB3YXkgdGhhdCBJIGNhbg0KYnlwYXNzIH RoZSBzZWFy
Y2hpbmcgZm9yIGEgZHVwbGljYXRlIG9yZGVyPyBhbmQganVzdC BoYXZlIGR1cGxpY2F0ZXMgYmUN
Cm92ZXJ3cml0dGVuIHdpdGggdGhlIG5ldyBvcmRlcj8NCiANCj MpIEEgTWl2YSBlbmQgdXNlciBo
YWQgaW5mb3JtZWQgbWUgdGhhdCB3aGVuIHRoZXkgY29uZmlndX JlZCBTeW5jaHJvIE5PVA0KdG8g
YWRkIHRoZSAibW0iIHByZWZpeCwgdGhlIHN5bmNocm9uaXphdG lvbiBwcm9jZXNzIHdhcyBzb21l
d2hhdCBmYXN0ZXIuDQpXaHkgd291bGQgdGhhdCBiZSBpZiBRQi BpcyBzZWFyY2hpbmcgdGhydSBh
bGwgb2YgdGhlIG9yZGVycyBhbnl3YXk/DQogDQo0KSBXaGF0IGNvbmZpZ3VyYXRpb24vc2V0dGlu
Z3MvLi4uZXRjIGluIFFCIGFuZC9vciBTeW5jaHJvIGRvIHlvdQ 0KcmVjb21tZW5kPw0KIA0KVGhh
bmtzLA0KUmljaA0KDQoJLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS 0tLS0gDQoJRnJvbTogTWl2YSBV
c2VyIEdyb3VwIFN1cHBvcnQgW21haWx0bzpncm91cHN1cHBvcn RAbWl2YS5jb21dIA0KCVNlbnQ6
IFRodSA1LzYvMjAwNCA0OjUzIFBNIA0KCVRvOiBXYWxsYWNlLC BSaWNoYXJkIEwgQ0lWOyBTeW5j
aHJvIFVzZXJzIA0KCUNjOiANCglTdWJqZWN0OiBSRTogW3NjdV 0gU3BlZWQgb2YgU3luY2hyb25p
emF0aW9uDQoJDQoJDQoNCglIaSBSaWNoLA0KCQ0KCVdpdGggZW FjaCBvcmRlciBNaXZhIFN5bmNo
cm8gYWRkcyB0byBRdWlja0Jvb2tzLCBpdCBmaXJzdCBuZWVkcw 0KdG8gcXVlcnkNCglRdWlja0Jv
b2tzIHRvIHNlZSBpZiB0aGF0IG9yZGVyIG51bWJlciBhbHJlYW R5IGV4aXN0cy4gSWYgeW91DQpo
YXZlIGEgaGlnaA0KCXZvbHVtZSBvZiBvcmRlcnMgaW4gUXVpY2 tCb29rcyBhbHJlYWR5LCB0aGlz
IHByb2Nlc3MgY2FuIHRha2UgYQ0KbG9uZyB0aW1lLg0KCQ0KCU ppbW15DQoJTWl2YSBTdXBwb3J0
IEVuZ2luZWVyDQoJUGxlYXNlIFJFUExZIHRvIGtlZXAgbWVzc2 FnZSBoaXN0b3J5Lg0KCQ0KCU1p
dmEgQ29ycG9yYXRpb24NCglBIEZpbmRXaGF0IENvbXBhbnkNCg lOQVNEQVE6IEZXSFQNCgkoODU4
KSA0OTAtMjU3MA0KCU1vbi4gLSBGcmkuLCA5YW0gLSA1cG0gKF BUKQ0KCQ0KCSoqKioqKioqKioq
KioqKioqKioqKioqKioqKioqKioqKioqDQoJRG8geW91IGhhdm UgcXVlc3Rpb25zPyAgV2UgaGF2
ZSBhbnN3ZXJzIQ0KCUNoZWNrIG91dCBvdXIgRkFRIGF0Og0KCW h0dHA6Ly93d3cubWl2YS5jb20v
c3VwcG9ydC9mYXFzDQoJKioqKioqKioqKioqKioqKioqKioqKi oqKioqKioqKioqKioNCglORVch
ICBNaXZhIFNlcnZpY2UgQ2x1Yg0KCVN0YXJ0aW5nIGF0IG9ubH kgJDE0OS95ci4NCglWaXNpdCB3
d3cubWl2YS5jb20vc3VwcG9ydCBmb3IgZGV0YWlscy4NCgkqKi oqKioqKioqKioqKioqKioqKioq
KioqKioqKioqKioqKg0KCQ0KCQ0KCS0tLS0tT3JpZ2luYWwgTW Vzc2FnZS0tLS0tDQoJRnJvbTog
V2FsbGFjZSwgUmljaGFyZCBMIENJViBbbWFpbHRvOnJpY2hhcm QubC53YWxsYWNlQG5hdnkubWls
XQ0KCVNlbnQ6IFdlZG5lc2RheSwgTWF5IDA1LCAyMDA0IDg6Mj ggQU0NCglUbzogc3luY2hyby11
c2Vyc0BtaXZhLmNvbQ0KCVN1YmplY3Q6IFtzY3VdIFNwZWVkIG 9mIFN5bmNocm9uaXphdGlvbg0K
CUltcG9ydGFuY2U6IEhpZ2gNCgkNCgkNCglBbGwsDQoJDQoJU3 luY2hyb25pemluZyBvcmRlcnMg
KGV2biBqdXN0IDEgb3IgMikgd2l0aCBRdWlja0Jvb2tzIDIwMD QgUHJvDQpkYXRhDQoJZmlsZSB3
YXMgZXh0cmVtZWx5IHNsb3cuIEluIGFuIGF0dGVtcHQgdG8gc3 BlZWQgaXQgdXAsIEkNCmNvbmRl
bnNlZCB0aGUNCglRdWlja0Jvb2tzIGZpbGUgdG8ga2VlcCBvbm x5IHRoZSBkYXRhIHNpbmNlIDFK
QU4yMDAyLg0KU3luY2hyb25pemF0aW9uDQoJd2FzIGZhc3Rlci BidXQgc3RpbGwgU0xPVzsgbWFr
aW5nIGl0IHZlcnkgYW5ub3lpbmcuDQoJDQoJPz8/IENhbiBhbnlvbmUgZXhwbGFpbiBob3cgTWl2
YSBTeW5jaHJvIGRvZXMgd2hhdCBpdCBkb2VzPyBpLmUuDQp3aG F0IGlzDQoJaXQgZG9pbmcvc2Vh
cmNoaW5nIHRocm91Z2ggaW4gUUI/IElzIGl0IGdvaW5nIHRocm91Z2ggZXZlcnkNCnNpbmdsZSBR
Qg0KCWludm9pY2UgZm9yIGVhY2ggTWl2YSBvcmRlcj8gLi4uZX RjLiBJZiBJIChXZSkgdW5kZXJz
dGFuZCBob3cgaXQNCmlzDQoJZG9pbmcgd2hhdCBpdCBkb2VzLC B0aGFuIG1heWJlIHdlIGNhbiBv
cHRpbWl6ZSBpdCdzIHBlcmZvcm1hbmNlLg0KCQ0KCQ0KCVRoYW 5rcywNCglSaWNoDQoJDQoJDQoN
Cg==

------_=_NextPart_001_01C4342E.76141109--

#4 · 05-07-04, 10:14 AM

Speed of Synchronization

------_=_NextPart_001_01C4345F.1284FF60
Content-Type: text/plain;
charset="utf-8"

Hi Rich,

1. If the order already exists, Miva Synchro will skip the order from
Miva
Merchant and go on with the next one in the list.

2. Unfortunately, there's no way to bypass the order number querying.
However, there are many other factors that can cause the time increase.
QuickBooks doe s a lot of data processing when adding a new order.

3. Their QuickBooks may be faster for other reasons, like more system
resources, less data to process, etc. Removing the "mm" prefix shouldn't
have much effect on the speed of order synchronization.

4. It depends on what you are trying to do. We really don't have
recommended
settings for QuickBooks since every user's instance is unique. You can't
really find two people using QuickBooks the same way. Everyone's
business is
different.

Jimmy
Miva Support Engineer
Please REPLY to keep message history.

Miva Corporation
A FindWhat Company
NASDAQ: FWHT
(858) 490-2570
Mon. - Fri., 9am - 5pm (PT)

***********************************
Do you have questions? We have answers!
Check out our FAQ at:
<A HREF ="http://www.miva.com/support/faqs <http://www.miva.com/support/faqs> ">http://www.miva.com/support/faqs <http://www.miva.com/support/faqs> </A>
***********************************
NEW! Miva Service Club
Starting at only $149/yr.
Visit www.miva.com/support for details.
***********************************

-----Original Message-----
From: Wallace, Richard L CIV [mailto:[email protected]]
Sent: Friday, May 07, 2004 5:26 AM
To: Miva User Group Support; Synchro Users
Subject: RE: [scu] Speed of Synchronization
Importance: High

1) What happens if the Miva order number already exists in QB? Does the
Synchro process abort with error? ...hang, etc?

2) Is Synchro telling QB to search through all of the orders, or does QB
do
it anyway, whenever an order is added? Is there any way that I can
bypass
the searching for a duplicate order? and just have duplicates be
overwritten
with the new order?

3) A Miva end user had informed me that when they configured Synchro NOT
to
add the "mm" prefix, the synchronization process was somewhat faster.
Why
would that be if QB is searching thru all of the orders anyway?

4) What configuration/settings/...etc in QB and/or Synchro do you
recommend?

Thanks,
Rich

-----Original Message-----
From: Miva User Group Support [mailto:[email protected]]
Sent: Thu 5/6/2004 4:53 PM
To: Wallace, Richard L CIV; Synchro Users
Cc:
Subject: RE: [scu] Speed of Synchronization

Hi Rich,

With each order Miva Synchro adds to QuickBooks, it first needs to query
QuickBooks to see if that order number already exists. If you have a
high
volume of orders in QuickBooks already, this process can take a long
time.

Jimmy
Miva Support Engineer
Please REPLY to keep message history.

Miva Corporation
A FindWhat Company
NASDAQ: FWHT
(858) 490-2570
Mon. - Fri., 9am - 5pm (PT)

***********************************
Do you have questions? We have answers!
Check out our FAQ at:
<A HREF ="http://www.miva.com/support/faqs <http://www.miva.com/support/faqs> ">http://www.miva.com/support/faqs <http://www.miva.com/support/faqs> </A>
***********************************
NEW! Miva Service Club
Starting at only $149/yr.
Visit www.miva.com/support for details.
***********************************

-----Original Message-----
From: Wallace, Richard L CIV [ mailto:[email protected]
<mailto:[email protected]> ]
Sent: Wednesday, May 05, 2004 8:28 AM
To: [email protected]
Subject: [scu] Speed of Synchronization
Importance: High

All,

Synchronizing orders (evn just 1 or 2) with QuickBooks 2004 Pro data
file was extremely slow. In an attempt to speed it up, I condensed the
QuickBooks file to keep only the data since 1JAN2002. Synchronization
was faster but still SLOW; making it very annoying.

??? Can anyone explain how Miva Synchro does what it does? i.e. what is
it doing/searching through in QB? Is it going through every single QB
invoice for each Miva order? ...etc. If I (We) understand how it is
doing what it does, than maybe we can optimize it's performance.

Thanks,
Rich

------_=_NextPart_001_01C4345F.1284FF60--

Announcement

Speed of Synchronization

Speed of Synchronization

Comment

Comment

Comment