Article ID: 274112 - View products that this article applies to.
This article was previously published under Q274112
This article has been archived. It is offered "as is" and will no longer be updated.
This article describes how to design a SQL CE (SSCE) application to improve performance and to minimize memory usage.
The performance of a SQL CE application may vary based on a number of factors. These factors include:
If you are using a WHERE clause, ORDER BY or JOIN, an index on the appropriate columns can improve performance tremendously. However, if you are running code similar to:
then indexes will not help.
Memory is constrained on the device. There are ways to minimize memory usage in SSCE. Here are a few tips:
317032Additionally, see the "Using SQL Server CE Temporary Databases" topic in SQL Server CE Books Online.
(http://support.microsoft.com/kb/317032/EN-US/ )HOW TO: How to Change the Temp Database Location in SQL Server CE For SQL Server CE 2.0
See the "Building Applications" topic in SQL Server CE Books Online.
Article ID: 274112 - Last Review: February 28, 2014 - Revision: 1.7
Contact us for more help
Connect with Answer Desk for expert help.