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

We have experienced the same problems in our app which is in production. We
are uppdating the database very often by getting data from our SQL Server.
Our app is small and I'm sure we are disposing everything correctly.

Our CE device, which is running Windows CE 5.0 is crashing every 2-3 days.
Our workaround so far has been to reset the device from our program every
day.

The error we get is Out of Memory if we leave it running.

We hope to se a servicepack or a new version without these problems very
soon. Our customers are killing us.

Kay



"An o' Neamus" <oneamus@xxxxxxxxx> skrev i melding
news:1191480769.967158.223910@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Greetings,

I wrote a very simple C# console application which was designed to
give us a rough idea on the performance and reliability of SQLCE (the
source code without metrics has been posted to this group recently).
What I've found is that there are major performance and reliability
issues with SQLCE 3.0 as opposed to SQLCE 2.0. Whereas SQLCE 2.0 seems
to be fairly consistent in terms of it's memory usage and the amount
of time taken to insert rows into the table regardless of the size of
the table (to a limit, after about 300,000 records it too has major
performance issues), SQLCE 3.0 seems to slow down noticably and
continually use more memory even after a few thousand records are
inserted and actually crashes (consistently) after 25592 records are
inserted!

What gives? Based on this it would seem that SQLCE 2.0 is far
preferable for an unattended device that needs an uptime of over 30
days whilst constantly (several times per minute) inserting into the
database.

Thanks for your thoughts on this...



.

Relevant Pages

  • Re: SQLCE performance from .NET CF v2.0
    ... Please remember when bulk inserting is being executed against SQL CE, ... > local database functionality. ... > database technology and I am considering switching to SQLCE at the same ... > execute the prepared statement again. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Random file access -cont
    ... You don't need SQL Server to use SqlCe. ... When you add a reference to the SqlCe DLL in your app, ... Tiffany called SQL Server CE Database Developmjent with the .Net Compact ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Is it just me or are there BIG problems with SQLCE 3.0?
    ... 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. ... issues with SQLCE 3.0 as opposed to SQLCE 2.0. ... days whilst constantly inserting into the ...
    (microsoft.public.sqlserver.ce)
  • question about how to handle if row exists
    ... Since this is not supported in SQLCE ... what is the recommended way of inserting new rows in the database with a ... customer_id is a primary key ...
    (microsoft.public.dotnet.framework.compactframework)
  • question about how to handle if row exists
    ... Since this is not supported in SQLCE ... what is the recommended way of inserting new rows in the database with a ... customer_id is a primary key ...
    (microsoft.public.sqlserver.ce)
Loading