Memory Issues and Light Database for Java ME
Hi all !
I've been using Apache Derby for my CDC app using Creme JVM. So far it works fine with small data (around 8 tables with total of 1000 small records of data). I've been testing it with around 26MB of user memory available in my pocket pc device.
Later on i tried csv processing for synchronization, downloading from wifi, extraction, etc, and it fails with OutOfMemoryError :-) I dont know if the available user memory is too small (I'm using ipaq messenger 6965, with 48MB user memory, the WM5 left me with 28MB to use) or is it my app or my database that consumes too much memory. I've been looking info about ipaq 112, which they say could have around 192MB of user memory, hee hee ..
I wonder too if there are other database with smaller memory print for mobile application ? I've been interested with db4o, but still unsure how to do relational things with it, i'm still new to it. I'm going to need simple joins.
If only Apache Derby got a simpler version for CDC app, which supports only basic sql operations and with smaller memory print. :-)
What do you think of this ? Please share your thoughts !