• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 437
  • Last Modified:

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?
0
bigmikese
Asked:
bigmikese
  • 4
  • 2
1 Solution
 
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
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
HoggZillaCommented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now