Click here to Skip to main content
15,885,032 members
Home / Discussions / Mobile
   

Mobile

 
QuestionSending SMSs from your Microsoft .NET Compact Framework-based Applications Pin
achari.ravi14-Mar-08 21:15
achari.ravi14-Mar-08 21:15 
GeneralRe: Sending SMSs from your Microsoft .NET Compact Framework-based Applications Pin
Rupesh Kumar Swami28-Mar-08 5:09
Rupesh Kumar Swami28-Mar-08 5:09 
GeneralRe: Sending SMSs from your Microsoft .NET Compact Framework-based Applications [modified] Pin
Parasmani Swamy29-Mar-08 1:29
Parasmani Swamy29-Mar-08 1:29 
GeneralSet dial-up connection entry in WinCE Pin
knetmasse14-Mar-08 5:04
knetmasse14-Mar-08 5:04 
GeneralChanging the page color of mobile application in asp.net Pin
tasnim514-Mar-08 0:44
tasnim514-Mar-08 0:44 
QuestionDLLImport CharSet=ChartSet.Ansi Pin
steve_rm13-Mar-08 4:40
steve_rm13-Mar-08 4:40 
GeneralRe: DLLImport CharSet=ChartSet.Ansi Pin
Ravenet13-Mar-08 17:08
Ravenet13-Mar-08 17:08 
GeneralSQL CE Performance so slow.... [modified] Pin
mac24nzmac24nz13-Mar-08 0:32
mac24nzmac24nz13-Mar-08 0:32 
Hi.

I'm changing an existing C#/Compact framework 2.0 from using DataSets as the data storage (backed up by XML) to SQL Mobile 2005 (as an offline DB only). I'm doing this because after changing each position of the DataSet we were writing the XML to file system (just in case of a crash, low power, etc). That became very slow under Windows Mobile 5 (RAM -> ROM change).

So I've just finished rewriting the application so that it used SQL Mobile 2005. When only one entry in the DB changes its a lot faster. Great.

But when I delete all data from the DB or I want to insert all records into the DB it takes 1-2 minutes (about 200 entries). This just seems to be way too slow. That means that it can only write about 3 entries per second....that seems really slow.

The read performance is very good.

I'm using Microsoft SQL Server Mobile Edition 3.0.5206.0 from Visual Studio 2005. The performance is bad when running it inside the debugger and using the same code started directly on the PDA (without the VS 2005 debugger running).

I'm not sure how to export my tables as SQL code to code project. Any ideas? or what info can I share which could help anyone (who can help meSmile | :) )

Okay, so I ran a test with a Symbol MC70 (Intel XScale 624 Mhz processor). For 158 entries it took over 2 minutes to delete the DB (I delete each DataRow individually - is this why the delete takes so long?). The inserts took quite a while too, about 30 seconds).

Why are these values so long?

The DB Table has a primary key (4 columns) & the DB Table has a total of 40 columns.

Thanks

Martin

modified on Thursday, March 13, 2008 10:48 AM

GeneralRe: SQL CE Performance so slow.... Pin
Mike Dimmick17-Mar-08 6:21
Mike Dimmick17-Mar-08 6:21 
GeneralRe: SQL CE Performance so slow.... Pin
mac24nzmac24nz19-Mar-08 10:26
mac24nzmac24nz19-Mar-08 10:26 
Questionmobile database connectivity Pin
achari.ravi12-Mar-08 21:32
achari.ravi12-Mar-08 21:32 
GeneralRe: mobile database connectivity Pin
mac24nzmac24nz13-Mar-08 0:06
mac24nzmac24nz13-Mar-08 0:06 
Questionlooking for sample code on using pocket outlook, excel and word object Pin
Kayu12-Mar-08 17:58
Kayu12-Mar-08 17:58 
GeneralRe: looking for sample code on using pocket outlook, excel and word object Pin
Arjun Marwaha16-Mar-08 20:20
Arjun Marwaha16-Mar-08 20:20 
NewsFree Introductory Windows Mobile 6 training for developers Pin
brucedkyle12-Mar-08 7:03
brucedkyle12-Mar-08 7:03 
Questionhow to change date & time in C# for PPC Pin
E_Gold12-Mar-08 3:32
E_Gold12-Mar-08 3:32 
AnswerRe: how to change date & time in C# for PPC Pin
mac24nzmac24nz13-Mar-08 0:38
mac24nzmac24nz13-Mar-08 0:38 
Questiondatabse connectivity Pin
achari.ravi12-Mar-08 1:11
achari.ravi12-Mar-08 1:11 
GeneralRe: databse connectivity Pin
Paul Conrad12-Mar-08 6:35
professionalPaul Conrad12-Mar-08 6:35 
GeneralRe: databse connectivity Pin
Ravenet13-Mar-08 20:14
Ravenet13-Mar-08 20:14 
QuestionUsing key combinations/short cut keys in Windows Mobile/Smartphone [modified] Pin
Parasmani Swamy10-Mar-08 0:56
Parasmani Swamy10-Mar-08 0:56 
GeneralTreo 600 application Pin
Are Jay7-Mar-08 17:09
Are Jay7-Mar-08 17:09 
GeneralSkins for PDA applications Pin
steve_rm7-Mar-08 6:36
steve_rm7-Mar-08 6:36 
GeneralMobil Development data problems Pin
Cory Kimble6-Mar-08 4:13
Cory Kimble6-Mar-08 4:13 
QuestionCapturing/gathering own mobile number - Smartphone Pin
Parasmani Swamy3-Mar-08 23:15
Parasmani Swamy3-Mar-08 23:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.