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