Etcf
01-16-2004, 07:41 PM
MySql 3.23.54 Running on a web shared host
I am not comparing the performance of the local and remote figures - but more a comparision between MySql and MS SQL on either like for like Local or Remote performance.
I have a regular requirement to upload/ export data to a MySql server - unfortunately 1,000's of rows. Tests are appends/ insert not updates.
Whilst I have not been able to get "LOAD DATA LOCAL INFILE..." working yet (and may not due to host issue) - my other tests have shown the following.
Test import data has 5 text fields with 10 chars in each, 27,000 records. Table already exists in the database. Tests performed on a local MySQL and MS SQL - plus remote MySql and MS SQL
1. using Premiumsoft Navicat as the gui client application for the import. Source in MS Access table format
1.1 Local connection 9 mins
1.2 Remote connection 48 mins
2. same table created in MS SQL and the same Access database used as the source. Using DTS Import in MS Enterprise Manager (roughly the same type of gui client on MS SQL as Navicat is on MySql.
2.1 Local connection 20 seconds
2.2 Remote connection 2 minutes
3. Tried MySql with 'SQLyog' as the client interface but I gave up after about 90 minutes on the remote test.
4. Have tried using Odbc (to update the remote MySql database) but this is very, very slow - and not an option.
5. Tried Import to the Local MySql (9 minutes) and then a data transfer from the Local server to the remote for this table only - but that took 44 minutes i.e. 9+44mins to achieve the same as an import (48 mins)
6. With ref to http://www.codingforums.com/showthread.php?s=&threadid=22880 "Importing and Exporting data with phpMyAdmin" - this effectively 5 above - since Navicat creates a 'dump file' I think.
I must be missing something - can't believe that Microshaft have got one over on MySql - for fast transfer of data to the server.
Thanks in advance for any thoughts.
Antony
p.s. 'Local' is actually a Windows box on the local network running MS SQL and a separate box running MySql. 'Remote' is one box running MS SQL and another of similar spec running MySql. The client applications (Navicat or browser) are running on a decent Win 2000 workstation.
I am not comparing the performance of the local and remote figures - but more a comparision between MySql and MS SQL on either like for like Local or Remote performance.
I have a regular requirement to upload/ export data to a MySql server - unfortunately 1,000's of rows. Tests are appends/ insert not updates.
Whilst I have not been able to get "LOAD DATA LOCAL INFILE..." working yet (and may not due to host issue) - my other tests have shown the following.
Test import data has 5 text fields with 10 chars in each, 27,000 records. Table already exists in the database. Tests performed on a local MySQL and MS SQL - plus remote MySql and MS SQL
1. using Premiumsoft Navicat as the gui client application for the import. Source in MS Access table format
1.1 Local connection 9 mins
1.2 Remote connection 48 mins
2. same table created in MS SQL and the same Access database used as the source. Using DTS Import in MS Enterprise Manager (roughly the same type of gui client on MS SQL as Navicat is on MySql.
2.1 Local connection 20 seconds
2.2 Remote connection 2 minutes
3. Tried MySql with 'SQLyog' as the client interface but I gave up after about 90 minutes on the remote test.
4. Have tried using Odbc (to update the remote MySql database) but this is very, very slow - and not an option.
5. Tried Import to the Local MySql (9 minutes) and then a data transfer from the Local server to the remote for this table only - but that took 44 minutes i.e. 9+44mins to achieve the same as an import (48 mins)
6. With ref to http://www.codingforums.com/showthread.php?s=&threadid=22880 "Importing and Exporting data with phpMyAdmin" - this effectively 5 above - since Navicat creates a 'dump file' I think.
I must be missing something - can't believe that Microshaft have got one over on MySql - for fast transfer of data to the server.
Thanks in advance for any thoughts.
Antony
p.s. 'Local' is actually a Windows box on the local network running MS SQL and a separate box running MySql. 'Remote' is one box running MS SQL and another of similar spec running MySql. The client applications (Navicat or browser) are running on a decent Win 2000 workstation.