Hi Mike. Thanks for your answer. I ran into this same article today by chance....and enjoyed what I read. It seems quite annoying that the SQL Server CE team haven't implemented UpdateBatchSize as SQL Anywhere from Sybase has. Still I'll have to live with it.... I guess I'll have a bit of a rewrite to do, so that this works. Still a 10x performance increase would be really great. Thanks Martin

I've only been able to manage that by using calls to the windows APIs which only work on some PDAs (on my development Dell X51V it works, on some Symbols it doesn't. I'm not sure why - no exception or anything, just the time doesn't change) Hope that helps, but maybe someone knows a C# way of doing that. Martin [DllImport("coredll.dll")] public extern static void GetSystemTime(ref SYSTEMTIME lpSystemTime); [DllImport("coredll.dll")] public extern static uint SetSystemTime(ref SYSTEMTIME lpSystemTime); public struct SYSTEMTIME { public ushort wYear; public ushort wMonth; public ushort wDayOfWeek; public ushort wDay; public ushort wHour; public ushort wMinute; public ushort wSecond; public ushort wMilliseconds; } public static void setSystemDate(DateTime newTime) { // Set the clock to this time SYSTEMTIME st = new SYSTEMTIME(); st.wMilliseconds = (ushort)newTime.ToUniversalTime().Millisecond; st.wSecond = (ushort)newTime.ToUniversalTime().Second; st.wMinute = (ushort)newTime.ToUniversalTime().Minute; st.wHour = (ushort)newTime.ToUniversalTime().Hour; st.wDay = (ushort)newTime.ToUniversalTime().Day; st.wMonth = (ushort)newTime.ToUniversalTime().Month; st.wYear = (ushort)newTime.ToUniversalTime().Year; //GetSystemTime(ref st); //st.wHour = (ushort)(st.wHour + 1 % 24); SetSystemTime(ref st); }

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 me:) ) 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

Try, da.Fill(dt,"Users"); Just a thought. Martin

Thanks for the suggestions..... Sofar I've been to Waikato Uni (Hamilton) in NZ and Osnabrück Uni (Lower Saxony) in Germany. I studied Computer Technology & German in NZ and whatever matching in Osnabrück. I love Network programming and driver design, but I want to work in Austria (not Australia) later. I'm not sure if the Austrian market is the place to be a driver designer (America would be better?), but maybe my assumption is wrong there. In my 2 years of work experience in Germany I haven't had much need for driver design or network programming (unfortunately) and its been more my generic IT knowledge and programming skills that have kept me going. P.S. definitely wouldn't do a CogSci or AI programme. Any more suggestions guys? Thanks Martin

Hi, I'm considering going back to University. I studied for 5 years in New Zealand and 3 Semesters in Germany (2x Bachelors + 1 Post Graduate Diploma).......now I'd like to continue my studies (Masters)......where are the best Computer Science Uni's in the world? Obviously Berkley & MIT, but what else will say something to employers other than this? What Unis stand out on a CV? I had some ideas, but I'm looking to extend my list, then go hunting for scholarships and programs that interest me: Helsinki (Finland) TU Munich (Germany) Karlsruhe (Germany) I'd consider anything where I can study in English or German. Any suggestions? Thanks Martin

I think that Ansett was already going down and that it may not have been the smartest buy. Its true that the NZ Govt (and Singapore???) bailed them out - and made ALOT of $$$ by doing so. They're supposed to be good, but I've always avoided them as they were much more expensive. I found it cheaper flying Emirates & Korean Air to NZ (from Germany/England) The NZ Govt didn't want Air NZ sold to Quantas, because Quantas was one of the few competitors in the (NZ) market.