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.

On Fri, 16 Dec 2005 17:31:35 -0600, "Rene" <(E-Mail Removed)> wrote:

>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.
>

You may think I'm nuts when I say this, but do you have a vitus
detector turned on the machine?

I've noticed that VS 2005 gets very slow sometimes when the virus
checker on my machine is turned on. When I turn it off things get a
lot faster. It's the McAfee checker

No I am certain I don't have a virus. I narrowed everything down to the data
reader reading loop as in:

while(myDataReader.Read())
{
// Read the data here.
}

If I don't read anything inside the loop and simply let the loop go through
the loop is very fast but if I read at least one filed inside the loop
things slow down to a crawl.

If I was to send someone my Access Database and the loop code, would anyone
care to try this to see if you get the same behavior?

Thanks.

By the way, the number of records being retrieved is around 7000.




"Rene" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>

Update:

Well, I closed the IDE and run the program directly by double clicking on
the compiled exe and things work normal that way. The data loads very fast
this way, controls paint on the screen a lot faster too etc.

Well, as long as it works fine like that I don't mind too much if it sucks
on the IDE. The only thing that I am really sorry about is the 5 hours that
I wasted and worry while troubleshooting these speed problems. I wonder how
many other people will end up waiting all this time too.

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.ma.../13/63199.aspx
__________________________________________________________


"Rene" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>

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#]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.ma.../13/63199.aspx
> __________________________________________________________
>
>
> "Rene" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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.
>>
>>
>
>

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.ma.../13/63199.aspx
__________________________________________________________


"Rene" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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#]" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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.ma.../13/63199.aspx
>> __________________________________________________________
>>
>>
>> "Rene" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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.
>>>
>>>
>>
>>
>
>

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.ma.../13/63199.aspx
__________________________________________________________


"Rene" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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#]" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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.ma.../13/63199.aspx
>> __________________________________________________________
>>
>>
>> "Rene" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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#]" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> 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.ma.../13/63199.aspx
>>>> __________________________________________________________
>>>>
>>>>
>>>> "Rene" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>> 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.
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

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#]" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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.ma.../13/63199.aspx
> __________________________________________________________
>
>
> "Rene" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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#]" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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.ma.../13/63199.aspx
>>> __________________________________________________________
>>>
>>>
>>> "Rene" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> 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.
>>>>
>>>>
>>>
>>>
>>
>>
>
>