Speed Question ( ADOCE, OLEDB, ADOCE.NET, SQL Server CE 2.0, SQL Server CE 3.0)

Speed Question ( ADOCE, OLEDB, ADOCE.NET, SQL Server CE 2.0, SQL Server CE 3.0)

Post by Marc Lefeb » Sat, 15 Oct 2005 22:57:19


I use evc++ 3.0 and evc++ 4.0

In my application, I have to read a big number of records.


With SQL Server CE 3.0
Can we use ADOCE ?
There is a speed improvment with ADOCE compare with SQL Server CE 2.0 ?
There is a good samples ?

With SQL Server CE 3.0
Can we use OLEDB ?
There is a speed improvment with OLEDB compare with SQL Server CE 2.0 ?
There is a good samples, other tha NortwindOledb ?


If we use VS 2005, can we compile our application build with evc++ 3.0 and
evc++ 4.0, and still continue to use ADOCE ?


Can you tell me if ADOCE.NET is fast ?
Is it faster then the ADOCE ?

There is a speed reason to use OLEDB in a .Net application ?
Or the class to manage database access are very fast.


Thank's
Marc
 
 
 

Speed Question ( ADOCE, OLEDB, ADOCE.NET, SQL Server CE 2.0, SQL Server CE 3.0)

Post by MSF » Wed, 09 Nov 2005 23:04:50


With SQL Server CE 3.0 (or SQL Mobile 3.0)
==> ADOCE is not supported. Only ADO.NET & OLEDB are supported.
==> NorthwindOleDb sample is in OLEDB. And IBuySpy sample is in ADO.NET

Some of the SQL Mobile 3.0 components are totally re-architected with the
feedback and customer pain points with SQL CE 2.0.
SQL Mobile most of the times is faster than SQL CE 2.0.

SQL Mobile supports parameterized queries, multi-user support and alot more.
Please go through SQL Mobile Books Online.

Thanks,
--
Laxmi NRO, SQL Mobile, Microsoft Design Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.