Hi,

If you are working with the source code, this is now fixed in svn trunk and it will be fixed in the next release. I would say that using the multi sites feature with SQLite may work ok if the aggregate traffic of all the sites is pretty low. For any site that is expected to handle a lot of traffic I would go with one of  the other database platforms. SQLite basically has one connection whereas the other dbs all have a pool of connections which is much more suited to a multi threaded application like web apps. If you get a lot of traffic SQLite performance will probably have problems because each request must wait its turn to use the same connection to the database, so a lot of simultaneous requests will probably result in not great performance.

For sites with relatively low traffic its can be a nice choice because its easy to deploy since there is no database to install, but it also can't work in Medium Trust hosting environments, so that is something else to be aware of.

Best,

Joe