06-29-2009, 08:48 PM
I did not compare xml and sqlite speed. By default, sqlite is slow, but it is possible to make it much faster. Use transactions. Use compiled queries.
I think xml should be used with small amount of data, eg < 1MB. Because it stores whole file + IXmlNode objects in memory. Sqlite file size is unlimited.
Cannot help with encrypting.
I think xml should be used with small amount of data, eg < 1MB. Because it stores whole file + IXmlNode objects in memory. Sqlite file size is unlimited.
Cannot help with encrypting.