Re: Is it just me or are there BIG problems with SQLCE 3.0?

Hi Bill,

It would also be important to have a repro example to test against 3.5 as well.

--
Ginny Caughey
Device Application Development MVP


"William Vaughn" <billvaNoSPAM@xxxxxxxxx> wrote in message news:O9lRu1dCIHA.4956@xxxxxxxxxxxxxxxxxxxxxxx
I encourage you to get up on MSDN Connect and start pounding on the SQL CE 3.0 team to help them repro the performance and crash cases you have experienced. I have passed your comments to the dev team directly but did not get much more than "It seems to run faster for us...". Since they have not shipped I think it would make sense for everyone to get these issues resolved.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"An o' Neamus" <oneamus@xxxxxxxxx> wrote in message news:1191824843.761884.215690@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Oct 6, 6:19 pm, "William Vaughn" <billvaNoS...@xxxxxxxxx> wrote:
One trick you might try is to keep a connection to the database open. If you
use the Open update Close technique, the database is compressed at the final
close. Keeping a connection open postpones this operation.


Thanks. The database was kept open for the entire test run. Another
poster (in this or another thread I started on this subject),
suggested closing the database occasionally to get around the problem
we were seeing (ie. the database engine causing a GPF). As SQL CE 2.0
doesn't crash and is much faster, we've elected to use this version as
opposed to SQL CE 3.0.

At this point, the only unanswered question we have is whether there
are any reasons at all (given that performance and reliability are
severely degraded) why we should even consider using SQL CE 3.0?

TIA



.

Relevant Pages

  • Re: Search fails, but only for a specific sequence
    ... a SPECIFIC production of my database displays this unusual ... Device Application Development MVP ... Scalehouse and Billing Software for Waste Management ... Huge speed advantage over SQL ...
    (microsoft.public.sqlserver.ce)
  • Re: How to read data from stand alone SQL CE database on mobile device from VB.net 2005
    ... Device Application Development MVP ... consider removing the IIS requirement for SQL Server but I don't ... I have a stand alone SQL CE database on my windows mobile device. ...
    (microsoft.public.sqlserver.ce)
  • Re: Multiple User Access through ADO?
    ... SQL Compact also can act as a Subscriber in a Merge replication scenario or synchronize with a common database using the Local Data Cache/ADO.NET Sync Services. ... "Ginny Caughey MVP" wrote in message ... Device Application Development MVP ...
    (microsoft.public.sqlserver.ce)
  • Re: SDF Database
    ... I'm using CTP6 still, and I can alter the schema ok, but I know of at least one person who had problems with a later version that sounds similar to what you're seeing. ... Device Application Development MVP ... I've checked the database with Chris' code, it is V 3.5 before and after opening in VS 2008... ... Ok I can open it now in SQL Management Studio 2008, but have to use sql statements there to alter it. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
Loading