Re: DataAdapter Fill method SLOOOOOW

Tech-Archive recommends: Fix windows errors by optimizing your registry

Shail,

I found the problem, please read one of my own replies posted at 1:25 AM.
The problem only happens when running the code in the IDE, when the code
runs by clicking the program exe everything is fine. I have no idea what's
going on in the VS 2005 IDE but performance is really bad compared with VS
2003.

Thakns.



"Sahil Malik [MVP C#]" <contactmethrumyblog@xxxxxxxxxx> wrote in message
news:uptdw3zAGHA.3140@xxxxxxxxxxxxxxxxxxxxxxx
> What is the database you are using? Did the DB change at all between your
> upgrade?
>
> - Sahil Malik [MVP]
> ADO.NET 2.0 book -
> http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
> __________________________________________________________
>
>
> "Rene" <nospam@xxxxxxxxxx> wrote in message
> news:Ou92ChpAGHA.2036@xxxxxxxxxxxxxxxxxxxxxxx
>> What happened??? I just upgraded one of my 2003 projects to VS 2005 and
>> now, when I call the Fill method of an OleDbDataAdapter passing a
>> DataTable as a parameter it takes a heck of a lot longer that it used to.
>>
>> Before, it used to take 1 second to fill up the DataTable but now it
>> takes around 24 seconds!! This is a grotesque difference!!
>>
>> I did NOT change a single line of code. All I did was upgrade to 2005.
>>
>> This seems like a huge bug and is hard to believe it can be happening so
>> I guess I must have a corrupted installation or something. Is anyone
>> experiencing similar problems? I tried it in two computers and I got the
>> same results.
>>
>> Any help is appreciated.
>>
>>
>
>


.

Relevant Pages

  • Re: Motherboard, CPU recommendations please
    ... DDR 333 RAM and two hard drives, Maxtor 80GB and Western Digital 120GB ... PCI card and at present am using AGP graphics in the form of Nvidia ... The first question I would ask is why you feel the need to upgrade? ... APG graphics and IDE devices will severely limit what you can do. ...
    (uk.comp.homebuilt)
  • Re: RAD Studio Roadmap Updated
    ... Neither is an upgrade to D2007. ... Rarely does anyone ever debug what they deploy. ... "in the box" with the 2007 IDE. ... If I'm going to have to jump though hoops I don't see that paying extra ...
    (borland.public.delphi.non-technical)
  • FC3 upgrade from FC2 and cdwriting with FC2
    ... I've been trying to upgrade from FC2 on my main workstation a Celeron 2.4Ghz ... with 512 Mb and 1 IDE 80 Gig drive. ...
    (Fedora)
  • FC3 upgrade and cdburning on FC2/3
    ... I've been trying to upgrade from FC2 on my main workstation a Celeron 2.4Ghz ... with 512 Mb and 1 IDE 80 Gig drive. ...
    (Fedora)
  • Re: D6 to D2006 (Win32 Only)
    ... I wish I could give reasons to upgrade, but the cost of the IDE, ... > upgrade several expensive components that require a purchased upgrade to ... > with 3rd party IDE experts. ...
    (borland.public.delphi.non-technical)