Weird memory leak

Hi there, I'm new to SQLite, and I'm using it on a Mac OS X project. 
It's really wonderful, and fast (once I figured out indexing).

The current problem I'm having is a memory leak -- however, it's a
little unusual. 

My program creates a single database with a few tables and gradually
adds about 14,000 rows to one of the tables.  The rows are added in
transactions of 100 rows at a time.

As this is going on, available system memory gradually drops to zero,
until the system starts paging.  However, the memory loss is not
attributable to any running process.  Looking at top, no particular
process's memory usage is increasing, but available system memory
still eventually drops to zero.

If I kill my SQLite program, most of the memory is reclaimed, but some
is not returned to the system until I delete SQLite's database file. 
This leads me to believe the OS is mapping the file somehow.  (The
database file is about 200 MB in size if the process runs to
completion.)

I've confirmed there aren't any other significant memory leaks in the
program -- if I simply comment out the line that performs the database
inserts, the behavior goes away.  (And, as I mentioned, the memory
usage of my app does not increase as it's running.)

Anyone know what's happening and how I can fix it?

Thanks in advance,

Steven


To unsubscribe from this group, send an email to:
sqlite-unsubscribe-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/