[Jay_]

Quote:

Originally Posted by Maxips2 Why would you want to port SQLite to MySQL?

It depends on the circumstances - I can think of a few scenarios in the past where I have wanted to port my SQLite database to MySQL purely for communication purposes. SQLite is a local embedded database engine, and as the name suggests it's only "lite" - that means complex tables packing loads and loads of data consisting of many advanced queries don't really meet the database engines goal as it's not designed for large scale production environments. Although technically it can be embedded too, MySQL generally is standalone. This makes communication with a MySQL database from an external source much easier. It also has performance tuning features and can normally handle large amounts of data much better.