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] -----------------------------------------------------------------------------