Slow export speed

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
f1nutter
Forum Contributor
Posts: 125
Joined: Wed Jun 05, 2002 12:08 pm
Location: London

Slow export speed

Post by f1nutter »

Hi folks

I currently use an MS Access db to serve ASP files, but am in the middle of changing to PHP and MySQL.

I have a table in Access that contains 18 columns and 4766 rows. I am exporting it to MySQL through MyODBC.

The exporting took over 5 minutes. I running a 750MHz Duron with 128Mb RAM. Does it usually take a long time to export large files or do I just need more mega-hertz, mega-bytes, etc. or is there something in the exporting that is converted, and can I can help by changing the settings (column names maybe) in Access first.

Any help no matter how techy would be great.
User avatar
llimllib
Moderator
Posts: 466
Joined: Mon Jul 01, 2002 2:19 pm
Location: Baltimore, MD

Post by llimllib »

well, It's not a very techy response, but 5 minutes for 5000 rows of data doesn't seem too absurd to me. Besides, how often do you have to do it? You shouldn't be repeating it again if you can avoid it.
Post Reply