CI with SQLite vs CI with MySQL

[eluser]Radou[/eluser]
Hello CI fellows,

I developed an app using CI with MySQL and it is reasonably fast, but have no idea yet on its scalibility, time will tell.

But lately I was reading about CI with SQLite, and that SQLite is much faster than MySQL in general.

The question now is : what are the pros and cons of using CI with SQLite in a production mode ? is it preferred to MySQL? is it secure ? would the app be much faster ?

Sorry if I ask lots of questions but they are all related and didnt find any good comparison on the net.

Thanks

Rad