M moko Sep 9, 2004 #1 Are there any tips and tricks to optimize SQL-CE used by .NET CF applications ?
J Jon Skeet [C# MVP] Sep 9, 2004 #2 moko said: Are there any tips and tricks to optimize SQL-CE used by .NET CF applications ? Click to expand... I've found that doing "normal" inserts can be very slow - doing them from native OLE DB code (either your own or SSCEDirect) helps enormously. Also, filling a DataTable without loading the key in the schema (IIRC) helped a lot when loading the data from the database. No doubt others have more ideas.
moko said: Are there any tips and tricks to optimize SQL-CE used by .NET CF applications ? Click to expand... I've found that doing "normal" inserts can be very slow - doing them from native OLE DB code (either your own or SSCEDirect) helps enormously. Also, filling a DataTable without loading the key in the schema (IIRC) helped a lot when loading the data from the database. No doubt others have more ideas.
F Finn J Johnsen Sep 10, 2004 #3 moko said: Are there any tips and tricks to optimize SQL-CE used by .NET CF applications ? Click to expand... This might be obvious, but creating a index in the right place improved a query from seconds to a fraction of a second (about 55 000 records). regards, Finn
moko said: Are there any tips and tricks to optimize SQL-CE used by .NET CF applications ? Click to expand... This might be obvious, but creating a index in the right place improved a query from seconds to a fraction of a second (about 55 000 records). regards, Finn
S Syed N. Yousuf [MS] Sep 11, 2004 #4 SQL Server 2000 Windows CE Edition 2.0 Query Processor Overview and Performance Tuning Approaches http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ssceqpop.mspx You can access SQL Server CE Knowledge Base articles at: http://support.microsoft.com/default.aspx?scid=fh;EN-US;KBHOWTO ( select ' SQL Server CE ' as the product ) Thank you! Syed N. Yousuf Microsoft Developer Support Professional This posting is provided "AS IS" with no warranties, and confers no rights.
SQL Server 2000 Windows CE Edition 2.0 Query Processor Overview and Performance Tuning Approaches http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ssceqpop.mspx You can access SQL Server CE Knowledge Base articles at: http://support.microsoft.com/default.aspx?scid=fh;EN-US;KBHOWTO ( select ' SQL Server CE ' as the product ) Thank you! Syed N. Yousuf Microsoft Developer Support Professional This posting is provided "AS IS" with no warranties, and confers no rights.
