Mysql

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....