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

Reply via email to