Re: DataAdapter Fill method SLOOOOOW

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Well .. all I can say is .. MS would be extremely interested in getting this
feedback so they can fix the issue, but they really need more information
than "It runs slow".

- 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:e5sEmi6AGHA.912@xxxxxxxxxxxxxxxxxxxxxxx
> Everything is identical, nothing changed except that the program was
> imported to VS 2005, in fact, if I run the exact same code using VS 2003
> (I have both versions installed in the same computer) the VS 2003 works
> nicely. Exact same code, exact same database exact same everything.
>
> I also notice that a custom graph that I have runs around 20 times slower
> in VS 2005 IDE than the 2003 IDE. Is really quite a difference, almost
> unacceptable because testing your code like that will drive you crazy!
>
>
>
>
> "Sahil Malik [MVP C#]" <contactmethrumyblog@xxxxxxxxxx> wrote in message
> news:%23xku9b6AGHA.3984@xxxxxxxxxxxxxxxxxxxxxxx
>> Well .. I saw that .. and it is really weird - you shouldn't see a
>> difference, which is why I was trying to zero in on the actual cause of
>> the issue.
>>
>> - 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:ucNKtn1AGHA.916@xxxxxxxxxxxxxxxxxxxxxxx
>>> 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: DelphiSpeedUp/DDevExtensions question
    ... There seem to be strange things going on in the IDE. ... I activate a project configuration, save all and close the project. ... Then I press Alt+P or click on the project menu and close it again and then suddenly the editor icon changes indicating that the project file needs to be saved (just from opening and closing the project menu) - and thus DDevExtensions probably cannot find an *exact* match, so no menu entry is highlighted. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: DataAdapter Fill method SLOOOOOW
    ... Exact same code, exact same database exact same everything. ... VS 2005 IDE than the 2003 IDE. ... >> Shail, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Deploying/Development without Visual Studio
    ... IDE so long the right libraries are referenced. ... under Platform Builder there is a set of exact same ... So should I use those under Platform Builder 4.2 or use the ones ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Command line compile error not present in IDE
    ... Were you ever able to resolve this error? ... We have the exact same problem, ... except in the IDE. ... Brian Eskra ...
    (comp.lang.basic.visual.misc)