MySQL Forums
Forum List  »  Microsoft Access

Really Slow DB upload
Posted by: Claire Thompson
Date: April 07, 2010 05:20AM

Hey there

We're using Microsoft Access to drop data into MySQL tables (hosted at bluehost.com) which we're later converting into ZenCart data. We're using an ODBC connection.

The original data is being pulled from an inventory management system that was invented by the Amish (as in, it's really almost not technological at all, it's so cumbersome) called GERS. We're not up to speed on the latest build of GERS, so we have to pull our data out in Access and then push it to the site with Access.

Anyway, running the queries from GERS into Access only takes a few minutes, but uploading them takes hours. Not all of the data changes each time, but if we try to compare the table and only append changes it takes a really, really long time. So what we're doing now is deleting the entire table and reuploading all of the data, which is still taking a very long time, but is quicker than the comparison version.

Does anyone have any tips on how to make our uploads go faster? The deleting part of the process takes the longest, which suggests to me that we have something back to front somehow.

Thanks in advance for any help.

Claire

Options: ReplyQuote


Subject
Views
Written By
Posted
Really Slow DB upload
4140
April 07, 2010 05:20AM
2068
May 03, 2010 07:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.