Wednesday, March 7, 2012

CPU Time required for acessing the sql server database from VC++ application

Hi All,
I am not sure whether i can post this qn. in this sql server forum.
I am accessing the sql server database from a VC++ application. I saw
that when the below statements are taking a CPU time of anywhere
between 5 to 15 %. I think some thing is wrong here..
myRecordSet.Open() //This is taking around 5 to 6 %of CPU time
similary the statement myRecordSet.Addnew() as well, is taking lot of
CPU time.
Why does it need so much of CPU time ?.Appreciate your inputs on this
Thanks
VanithaAre you monitoring CPU on the client or the server?
<vanisathish@.gmail.com> wrote in message
news:1126061226.918105.220330@.g43g2000cwa.googlegroups.com...
> Hi All,
> I am not sure whether i can post this qn. in this sql server forum.
> I am accessing the sql server database from a VC++ application. I saw
> that when the below statements are taking a CPU time of anywhere
> between 5 to 15 %. I think some thing is wrong here..
> myRecordSet.Open() //This is taking around 5 to 6 %of CPU time
> similary the statement myRecordSet.Addnew() as well, is taking lot of
> CPU time.
> Why does it need so much of CPU time ?.Appreciate your inputs on this
> Thanks
> Vanitha
>

No comments:

Post a Comment