Problems with Beta 2

[Graham McKechnie]

Hi all,

I've just build a machine with a new version of XP Pro to test Beta 2.

The install of VS Beta 2 and Sql Server 2005 went ok. And that is all that
is on this machine.

I then tried moving one of my pocket pc 2003 CF projects to the new machine.
I opened this project in VS 2005 and it converted it all ok. The only
problem is when I try to compile I get errors. The first one was to do with
SqlServerCe not found. So I changed the reference to SqlServer 2005 ( can't
remember the directory structure now - i'm in the middle of rebuilding the
same machine) it then complained about System.Data.Common and needing to add
a reference to it. Isn't common in Data anyway?

Can some one advise me how to get around this problem.

Before I decided to start over I tried to write a test app for my new Window
mobile 5.0 SmartPhone, (it's the reason I decided to waste the day) but I
couldn't get it to connect to either the real device or the SP5 emulator.
Something about network problems. I also had problems installing the Windows
mobile 5.0 SDK. It was hanging at the end of the install. I installed Active
Sync 4.0 from that ok and the phone hooked up to that ok

I know this stuff is still beta, but I expected I'd do a little better than
I have, especially since I'm starting with a new machine, which has had all
updates applied.

I hope you guys have some good tips - because today has just been a bit of a
waste.

Regards
Graham

 

[Ginny Caughey [MVP]]

Hi Graham,

The RC build I'm working with is a lot better - especially since it includes
DMA access to the emulators in addition to the old network connection. Since
this is a virgin machine you're installing on, you'll also need .Net 1.1
with service patch if you don't have that already. If you're a MSDN
Universal subscriber, I'd suggest just waiting a bit until the RTM build is
available.

 

[Ginny Caughey [MVP]]

Graham,

I meant to ask you if you've had performance problems with JOINs with large
tables in SqlCe.

 

[Graham McKechnie]

Hi Ginny,

Well the latest app does have some pretty deep joins - 6 tables in one.
So far no performance problems. I was considering denormalising some of the
tables, but at this point the performance is good. However I did mention in
that email a week or two ago, that I'm only using small amounts of data at
the moment. They still haven't got around to converting the real data. Your
question therefore makes me quite nervous<g>. I've never really had a
problem getting data, it was always inserts and updates that I thought were
slow.

That as one of the reasons for trying to get Beta 2 going, because of the
supposd better performance.

As far as I know it installed Net 1.1 with SP3, so I didn't expect any
problems there. Its a new day, so I'm just about to have another go. I
picked up a hint about installing Mobile 5.0 SDK, so I've removed all virus
checking stuff from the machine.

The golf app has only a max of 3 joins, its certainly got more data, but I
wouldn't call it large. Frank's drug databases were big and that
performorned ok database wise. The performance of populating 6 tabcontrols
in his app was not so hot though. In the Intermec app I've written a new tab
control ( needed the finger sized tabs) so performance isn't an issue with
that.

I can't get the RC build, so I'm stuck with Beta 2 for the moment. If it
doesn't work today then I will just have to wait for the release. I'll let
you know how it goes.

Graham

 

[Ginny Caughey [MVP]]

Hi Graham,

I didn't intend to make you nervous about performance with SqlCE if you're
not having issues. <g> I'm just trying to help track down a performance
issue that somebody else is having and knew that you had some apps
(especially the medical one) that worked with some large tables in
production.

With the release date for VS 2005 at November 7, it shouldn't be that long
before we all have final bits.