UPS Auto Export Very Slow to SQL 2005 database - Native ODBC driver.

We are running WorldShip 10 on XP SP2 and SQL 2005. When shipping packages the "Auto Export after every shipment" is very slow. It can take a 1.5 minutes. The import is fine, about 2 seconds.

We are writing general data to our database. Tracking, weight, reference number.  The server is in a different state but we are connected via T1 and our other shipping stations are exporting fine.

I do not know much about databases, but our DBA said that the database is fine. Does anyone have any insight or solutions?
bigmikeseAsked:
Who is Participating?
 
HoggZillaConnect With a Mentor Commented:
I found documents at worldship.ups.com and the follwoing link:
http://www.stoneedge.com/help/OM_DOC/UPS/UPS_WorldShip_Setup_Full_Doc.html
0
 
HoggZillaCommented:
I thought WorldShip 10 runs on MSDE 2000, not 2005. Did you upgrade? Check out this situation and resolution.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23703836.html 
0
 
bigmikeseAuthor Commented:
Thanks for the info. How does UPS WorldShip use MSDE? Our server is running SQL 2005. We use ODBC to export the shipping data to our server running SQL 2005.  

Mike
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
HoggZillaCommented:
As I understand, the WorldShip application uses an MSDE 2000 database. If your Export process has issues it is likely with this UPS database.  Perhaps UPS offers support in the way of re-indexing thier database? I apologize that I cannot be of much more help.
0
 
HoggZillaCommented:
According to UPS The Automatic Export After Process Shipment option is ONLY recommended for users with a standalone installation of the Order Manager. If you have a network installation of the Order Manager with multiple users, run this process once, at end of day.
The documentation does not explain WHY they reccomend this, but here it is.
0
 
bigmikeseAuthor Commented:
In what document did you find this info? Do you have a link?
You've have a been a great help. Thanks.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.