CE Database Optimizing

I have an app written in VB.NET that runs on Win CE 5.0. I'm pressing right up against the 64mb process limit in this environment and I need help to resolve this. The app uses Sql Server Compact 3.5, and this seems to take several megs of RAM - if we can replace this with another solution that isn't so memory intensive, I think that could help a lot. I need someone to propose and implement a solution that will accomplish this. The database is used only to read data - the app does not modify or persist anything into the database. It has 9 tables and 14 indexes. All the code to access the database is contained in one project, and all the data is returned as typed objects or lists of objects. The main class library used to interface with the database is attached, as well as the SDF database file. The data classes referenced in the [login to view URL] file will be provided later. Here are the requirements of this project: 1) Reduce the RAM footprint dramatically - SqlSever seems to consume 2-3 megs, I'd like the new solution to be under 100k. 2) Cannot affect the access performance. Sql Server isn't super fast...but good enough, the new solution will need to be the same speed or better. 3) I need to be able to rebuild the data file on a monthly basis from my desktop machine (this data changes all the time, the process of creating a new SDF file is easily done via SSIS. I will need similar automation to create a new file...whatever format that may be) 4) The new solution can be in VB.NET or C# 5) I need this a successful implementation within a week of acceptance Here are some of the options I think might work (in no particular order) - I'm open to other suggestions: 1) Somehow get the Sql Server DLL running outside of the process memory. I have plenty of RAM on this box...so if SqlServer were running in it's own process this would be fine. I just don't know how independent apps can communicate if we did this. 2) Replace SqlServer with another database solution, such as SQLite. (This seems like the best solution to me) 3) Serialize the data into some sort of XML file with associated index files. ## Deliverables AMENDMENT: After deliberation I think my suggested solution #1 is the best alternative. And after googling around, it seems CE 5 has a Point to Point Message Queue that is well suited for this purpose. So please update your bids to reflect these new requirement: 1) Write a wrapper app to my provided [login to view URL] class that will support communication via Message Queue 2) Create a client version of the Message Queue to communicate with the wrapper app 3) The classes will need to be binary serialized for transport through the queue - some of the classes have been coded for this, others will need to be tweaked to support this. I will upload a full testbed app that includes all the IO classes. I am also extending the bidding timeframe for this project. Thanks, Walter