Page 1 of 1

Slow export speed

Posted: Mon Sep 02, 2002 11:49 am
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.

Posted: Mon Sep 02, 2002 12:40 pm
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.