{"id":5612,"date":"2014-04-04T05:07:32","date_gmt":"2014-04-04T05:07:32","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/04\/04\/memory-usage-of-sql-server-ce-collection-of-common-programming-errors\/"},"modified":"2014-04-04T05:07:32","modified_gmt":"2014-04-04T05:07:32","slug":"memory-usage-of-sql-server-ce-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/04\/04\/memory-usage-of-sql-server-ce-collection-of-common-programming-errors\/","title":{"rendered":"Memory Usage of SQL Server Ce-Collection of common programming errors"},"content":{"rendered":"<ul>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn Hi,I&#8217;m wondering about the memory usage of SQL Server Ce and the Compact Framework.I&#8217;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:\u00a0\u00a0\u00a0 32 MB &#8211; CLR &#8211; SQL-Server Runtime &#8211; parts of my database file hold in memory2. Is SQL Server Ce swapping parts of my database file into my process memory? \u00a0\u00a0\u00a0 If so, is there a chance to group some tables, that they are swapped together to increase\u00a0 \u00a0 performance?3. Means big databases big memory usage in my process memory?Thanks,Stefan<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn1<\/p>\n<p>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.<\/p>\n<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn2<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>msdn Hi,I&#8217;m wondering about the memory usage of SQL Server Ce and the Compact Framework.I&#8217;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:\u00a0\u00a0\u00a0 32 MB &#8211; CLR &#8211; SQL-Server [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5612","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/5612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=5612"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/5612\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=5612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=5612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=5612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}