I wanted to use "SQL Server CE 3.5" and "Microsoft Sync Services" to provide a distributed solution, where each client would have their own local database (No. of such users is not very high).
Brochure says "SQL Server CE 3.5" Supports ADO.NET, LINQ to SQL, LINQ to Entities and the ADO.NET Entity Framework. Does that mean VFP/ADO cannot use it?
Problem: SQL CE allows only OleDB Connection, which I guess means Cursor Adaptor with ADO has to be used, Which is very slow compared to SPT/ODBC combination. I tested by downloading a huge table with following results:-
SPT/ODBC: 38.5 Seconds
CursorAdaptor/ADO/OleDB: 120.0 Seconds
Even Downloading a few fields only using CA by specifing SelectCmd with UseCursorSchema=.F. resulted in poor comparative performance.
Any suggestions ? IF SQL CE solution is not possible with VFP then can such a distributed solution be built using Firebird ?
Aman
-------
Lets fly away to the Land where there is Love & Peace