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