I have a CVS datafile that I am importing into a hypersql DB with a single table, in via a java program which is running on a mobile device with 33mb of FREE memory (64mb total memory). I am simply parsing the lines, and creating insert statements in a loop. When hypersql loads with the JVM, I see my memory drop from 33 to 25 mb's.....then, even though it is only a 5mb file, I see my memory graddually drop from 25mb to 0, thus running out of memory....
If I have a 5mb cvs, what can I expect in terms of memory consumption? Any idea what is going on?