Thanks. I did force GC in the development IDE but still that doest solve the problem.
Is it possible to set a heap size limit to sqlite - i noticed this is possible in C, but is anyone aware of a JAVA equivalent way? Thanks Jonas Sandman wrote: > > I guess it's not as simple as that you're application is hogging the > Java VM so much that the garbage collector is never running? You can > always force it to run explicitly if so... > > /Jonas > > On Fri, Feb 1, 2008 at 1:46 PM, zqzuk <[EMAIL PROTECTED]> wrote: >> >> Hi, I am using SQLite 3.5.4, my application has encountered a memory >> management issue which I think is caused by sqlite. I have searched the >> forum and found this thread describing most similar situation as mine >> >> http://www.nabble.com/Memory-Usage-to13798003.html#a13850915 >> >> My application is accessing sqlite through JAVA on local machine, >> windows xp >> sp2, there are 4 threads accessing 4 *different* databases at the same >> time, >> each doing 2 million inserts to *different* databases. >> >> I have noticed that after about 3 hours, the system slowed down >> dramatically, such that processing every 1000 records(then 1000 inserts) >> took now 20 mins - 1 hr instead of sever seconds at the very beginning. >> I >> then checked the resource monitor and found all of my 2 gb memory has >> been >> used. >> >> I searched this forum and found talks about similar issues but solutions >> seem to be re-compiling sqlite in C using new parameters, but I am using >> JAVA and would like to know whether there is alternative/equivalent >> solution? And also the above thread I quote mentioned that >> closing/reopen >> connection can free up resources that sqlite occupy, i would take this >> as a >> simple but dirty workaround? >> >> >> Please may I have you suggestions , many thanks! >> >> -- >> View this message in context: >> http://www.nabble.com/memory-issue-with-large-amount-of-inserts-tp15225948p15225948.html >> Sent from the SQLite mailing list archive at Nabble.com. >> >> >> >> ----------------------------------------------------------------------------- >> To unsubscribe, send email to [EMAIL PROTECTED] >> >> ----------------------------------------------------------------------------- >> >> > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > -- View this message in context: http://www.nabble.com/memory-issue-with-large-amount-of-inserts-tp15225948p15226830.html Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
