datasets vs sqlce

  • Thread starter Thread starter mikeb
  • Start date Start date
M

mikeb

Storing and searching data in datasets within an application with large
amounts of data appears slow.

Would one recommend using sqlce for a large number of records being stored,
over the use of datasets?
 
Yes, it is recommended. We know of SQL CE databases with 100000+ rows.
You can complement SQL CE with Datasets; just limit number of rows loaded
into memory to 200-300.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
 
Great, thanks for this. Thats what I need to hear to move forward.


"Ilya Tumanov [MS]" said:
Yes, it is recommended. We know of SQL CE databases with 100000+ rows.
You can complement SQL CE with Datasets; just limit number of rows loaded
into memory to 200-300.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
From: "mikeb" <[email protected]>
Subject: datasets vs sqlce
Date: Wed, 16 Feb 2005 14:15:53 -0800
Lines: 8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
Message-ID: <#[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: dsl-66-243-234-82.elltel.net 66.243.234.82
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.dotnet.framework.compactframework:22672
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Storing and searching data in datasets within an application with large
amounts of data appears slow.

Would one recommend using sqlce for a large number of records being stored,
over the use of datasets?
 
Back
Top