Una de las formas para importar datos en MySQL es el comando LOAD DATA INFILE. Es más rápido que un dump, ya que se leen los datos en bruto, en lugar de sentencias SQL. El tiempo de importación depende del motor que use la tabla, por ejemplo, MyISAM puede ser 40 times más rápido que Innodb. Vamos a probarlo: Preparación Voy a utilizar MySQL 5.1.36 (64 bits MacOS X) para hacer las pruebas....
One of the ways to import data into MySQL is using the LOAD DATA INFILE. It is a faster method than recovering from a dump, as it’s raw data instead of SQL sentences. The import time depends on the table engine, for example, MyISAM can be 40 times faster than Innodb. Let’s benchmark this: Preparation I’m gonna make some benchmarking using MySQL 5.1.36 (64 bits MacOS X). I’ll need a big table, so I’ll take City from the World Database and create a huge table called “city_huge”:...
2009 Starts quite interesantly. This Monday took place the first Warp Talks, a project of training between employees at Warp Networks. The last Monday of the month will take place a new Warp Talk. koke and me where the first speakers. I made an introduction to subversion, and he did a talk about 10 things you might not know about MySQL. Koke took a camera and recorded our talks at the same time they were being broadcasted at justin....