SQLite3 in Embedded Linux NOR MTD Flash

SQLite3 in Embedded Linux NOR MTD Flash

The embedded system has M68K Architecture (MCF547x based), with colilo and
linux kernel 2.6.10 it used MTD (memory Type Device) NOR Flash (Spansion
make). There is around 32 MB of data to be managed (all in forms of
records) and memory available is 40MB as an MTD partition (JFFS2
filesystem). I wanted to understand the performance related problems or
any other memory related problems which i can encounter while doing this
exercise of using SQlite3 (amalgamation version).
By Memory related problem i meant frequent defrag operaton of memory
partition (since that 32 MB of database will be modified almost every
second).
Any experience/insights on this requirement will be very much helpful.
Please share your experience on what has to be taken care.