I have a data integration lab and was testing Talend Open Studio. I created a 138Mb text file (comma-separated) and ran it into a MySQL table. The runtime was about 8 minutes.
The lab setup is as follows
- Source computer running Talend Open Studio 4.1.0. Laptop with 3Gb RAM, 32-bit Athlon chip, Windows 7 Professional.
- Target computer. HP wtih 2Gb RAM, 32-bit Pentium 4, Fedora 11.
- Network. Wireless N connection.
- Data. A simple 3-column file with 1,000,000 records into a 3-column MySQL table.