Aseem Rastogi wrote:
Hi All,
I am planning to migrate to SQLite for my embedded system application.
Currently we have a flat text file which we read and write using normal
C++ routines. Whole of the configuration is written everytime some
change happens. We do it using ofstream. For reading any object, we keep
all the objects in memory and return from there (to prevent file read
every time). This takes up a lot of memory but makes it faster.
I am a bit concerned about following issues while upgrading to SQLite :
1. How does SQLite behave as compared to our current approach regarding
I/O access time ?
2. How much disk space does SQLite take as compared to flat text file ?
If somebody has some benchmarking data for these issues, it will be
really helpful if he can enlighten me on this.
Thanks in advance,
Regards,
Aseem.
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.
