Large (Product/Inventory) Data Text Updates To MySQL?

[olimits7]

Hi,

Does anyone deal with large product/inventory data updates to mySQL?

If so, how long do your updates take to finish? How big is your file, and how many rows of data does it contain?

I'm just trying to benchmark my website updates against other people's data website updates. My data takes a while to upload and, and I'm trying to find better methods of uploading my updates to mySQL.

Thank you,

olimits7

[wingslevel]

o7, are you updating by query or paste append? unlikely you are running into any kind of software or hardware constraint with an ecom db - mysql can handle millions of records, even on a slow server.

don't know how db savvy you are, but there are lots of layers of expertise in managing a large db. think structure (relationships), indexes and stored procedures. then there is proper management of backups, resources and disk space.

if you have specific questions, or want to post more specifically how you are appending data, i suggest you use the database forum. the other solution would be to use craigslist to find somebody local to come by and have a look at what you are doing....