SQLite performs inserts 8-14 times faster then InnoDB / MyISAM
SQLite performs updates 4-8 times faster then InnoDB and as fast as MyISAM
SQLite performs selects 2 times faster than InnoDB and 3 times slower than MyISAM
SQLite requires 2.6 times less disk space than InnoDB and 1.7 times more than MyISAM
Allowing null values or using synchronous=NORMAL makes Read More →