Memory Usage of SQL Server Ce

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 memory

2. 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
You only need SQL CE memory for your connection object and the data objects that you have currently loaded. The remaining database resides on disk.|||Thanks,
Stefan