Memory Usage of SQL Server Ce-Collection of common programming errors
.png)
msdn Hi,I’m wondering about the memory usage of SQL Server Ce and the Compact Framework.I’ve heard I can use only 32 MB per process. SQL Server Ce runs in process and my database file is about 60 MB big.1. Does that means, I can only use for my application: 32 MB – CLR – SQL-Server Runtime – parts of my database file hold in memory2. Is SQL Server Ce swapping parts of my database file into my process memory? If so, is there a chance to group some tables, that they are swapped together to increase performance?3. Means big databases big memory usage in my process memory?Thanks,Stefan
msdn1You only need SQL CE memory for your connection object and the data objects that you have currently loaded. The remaining database resides on disk.
msdn2