CI with SQLite vs CI with MySQL

[eluser]Stolz[/eluser]
It all depends on the kind of SQL usage of your application.

Sqlite is not recommended if you have many client programs accessing a common database over a network*, or a high-volume website with high concurrency, or you use very large datasets (*NOTE: When both sqlite file and webserver are on the same host then is not an acces over the network).

In other cases, specially if the number of SELECTs is much greather that INSERTs or UPDATES, Sqlite can be much faster.

Read the official doc for knowing when is recommended (or not) to use SQLite over another RDBMS.

Also, have in mind that, ASAIK, SQLite 3.x is supported in Codeigniter only using the PDO driver.