Christian Smith wrote:
John Stanton uttered:
In general you must expect Sqlite to use more of all resources
compared to a flat file. After all Sqlite is a flat file with
additional logic.
Except updates and selective reads will be cheaper in general, as less
IO is required due to additional logic.
Storage will go up, however. SQLite trades CPU cycles for IO compared to
flat file access.
Christian
Sqlite is more than one flat file. It is impossible for it to use less
resources than one flat file.
The only advantage you would gain from Sqlite is in the case where you
use the flat file inefficiently. Sqlite is useful when you want data
management and SQL access implemented in a very elegant and simple way.
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \