When I'm performing a large amount of selects of GLOBs/thumbnails from an 
ongoing SQLiteConnection, I'm having a problem where the Windows Active Mapped 
File will constantly grow out of control in size (memory leak?). This is under 
Windows 7, using a .Net Framework 4.0 C# application with System.Data.SQLite 
1.0.105.1. This is not the optional disk cache that can be removed from RAM, 
but rather a Windows Mapped File marked as 'active' that will eat up precious 
RAM, and I've seen as high as 4GB when I let it go on.

Active Mapped Files cannot be seen under Windows Task Manager, and won't count 
against the memory usage for a process, rather one will need a Microsoft 
utility called RamMap to see the problem: 
https://technet.microsoft.com/en-us/sysinternals/rammap.aspx

Here is a small test application I created to help isolate the issue. All the 
application does is read BLOBs/thumbnails from a table in an infinte loop and 
throws them away. The application itself uses very little RAM.
http://i.imgur.com/mod5ISX.png

Here's an example of The Active Mapped File growing to insane sizes while my 
test application is running and the connection is still open. The active column 
is the one of concern:
http://i.imgur.com/lVV97m7.png

Here are another two images of the change in RAM usage in Task Manager, before 
and after closing the process, even though the process itself shows very small 
RAM usage under all memory columns:
http://i.imgur.com/LRzzUFc.png
http://i.imgur.com/k5zNkLj.png

If anyone knows how I can prevent the Active Mapped File from continuously 
growing larger, please let me know. I've tried changing the Connection String, 
calling different methods on the SQLiteConnection (reset and clear), and 
ensured I was disposing everything appropriately, but I haven't managed to find 
how to reduce the the Active Mapped File size while the connection remains.

Thank you for any help on the matter, and sorry for the long explanation.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to