Re: Problems with Beta 2

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.

--
Ginny Caughey
..NET Compact Framework MVP


"Graham McKechnie" <gmknospam@xxxxxxxxxxxxxx> wrote in message
news:eNhoca01FHA.3180@xxxxxxxxxxxxxxxxxxxxxxx
> 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]" <ginny.caughey.online@xxxxxxxxxxxxxx> wrote in
> message news:%23ppeM1w1FHA.2616@xxxxxxxxxxxxxxxxxxxxxxx
>> Graham,
>>
>> I meant to ask you if you've had performance problems with JOINs with
>> large tables in SqlCe.
>>
>> --
>> Ginny Caughey
>> .NET Compact Framework MVP
>>
>>
>> "Graham McKechnie" <gmknospam@xxxxxxxxxxxxxx> wrote in message
>> news:ODvDp1u1FHA.736@xxxxxxxxxxxxxxxxxxxxxxx
>>> 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
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: suggestions please
    ... I am mostly interested in what SQLCE 3.0 had to offer... ... Displaying in landscape and anchoring are not necessary but any app coming ... VS2005 isn't even in Beta ... > features will be great, but I don't know that they'll be that much better. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Problems with Beta 2
    ... The golf app has only a max of 3 joins, its certainly got more data, but I ... I can't get the RC build, so I'm stuck with Beta 2 for the moment. ... Graham ... >> installing the Windows mobile 5.0 SDK. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: In need of 5 TS connections
    ... But if there are no unused workstations, the cost of installing ... If the ts is set up to host the user desktops, and the app is installed on ... >>> only thing I had to do was add the TS licensing ...
    (microsoft.public.windows.server.sbs)
  • Re: Run ADO/OLE DB from a CD-R
    ... > I need to get my VB6 app. ... > installing any files onto the host machine, or making any registry entries of ... > also have had Visual Studio installed, however on all other machines, the ADO ... Do you mean the bound-control 'ADODC' when you say 'ADO control'? ...
    (microsoft.public.data.ado)
  • RE: Beta 2007 Software
    ... Is it normal to receive an automatic prompt for installing the beta ... Patrick Schmid [OneNote MVP] ... .Will these files cause a problem when trying to reinstall 2007? ...
    (microsoft.public.office.developer.vba)