M
moko
Are there any tips and tricks to optimize SQL-CE used by .NET CF
applications ?
applications ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jon Skeet [C# MVP]
moko said:Are there any tips and tricks to optimize SQL-CE used by .NET CF
applications ?
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
moko said:Are there any tips and tricks to optimize SQL-CE used by .NET CF
applications ?
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]
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.
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.