Re: overcome increase in virtual memory
From: The Outlander (TheOutlander_at_Gmail.com)
Date: 12/17/04
- Next message: William \(Bill\) Vaughn: "Re: ADO Command Object with Array Parameter"
- Previous message: Chris Kettenbach: "ADO Command Object with Array Parameter"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 16 Dec 2004 19:38:50 -0500
I have had the same problem ... I got the latest service packs for SQL and
the latest MDAC which claims to have fixed this issue.
We have had an issue with continuous inserts. I tried adding a sleep and
that didn't help much but u can try all these fixes. It is a bug in the ADO
that they claim to fix. We came with a workaround and that was not to use
inserts that fast which works I think ... but the other developer took over
so I am not sure on the status.
- Nik
"Poonam Keshwani" <Poonam Keshwani@discussions.microsoft.com> wrote in
message news:47B5FC51-A42E-410D-BADD-7C67E65D0460@microsoft.com...
> Hello,
> My application is using ATL COM dll(VC++, VS 6.0 SP 5 OS: Win 2003/ 2000)
in
> an ATL COM Service
> COM Exe connects to MS SQL Server 2000 database using dll.
> The dll does all database operations referred by COM Service.
> In dll, ADO (MDAC 2.6) connects to MS SQL Server 2000 database and
> ADO::ConnectionPtr's Execute method is used for record insertion. In my
> application, insertion in a table occurs continously and I have found that
> during insertion virtual memory increases continously by 8 kb.
> Parallel to this, there are many other application routines called. I am
> sure that this increase is only during database insertion and not by any
> another routine.
>
> I don't know how to overcome this increase in memory.
> I also used MDAC 2.8 but the problem persists.
>
> Thankyou for any suggestion.
>
- Next message: William \(Bill\) Vaughn: "Re: ADO Command Object with Array Parameter"
- Previous message: Chris Kettenbach: "ADO Command Object with Array Parameter"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
