Re: ADODB Command memory leak

Hi,


See if it does not help

http://support.microsoft.com/default.aspx?scid=kb;en-us;248014

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"khalprin" <khalprin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ACD0680A-59E1-4179-BEA8-1AFF685C6441@xxxxxxxxxxxxxxxx
> Hello,
>
> I'm tracking down a memory leak and have narrowed it down to the single
> line
> of my code that calls the Execute() method of the ADODB Command object.
>
> In this case, the Execute() is executing a query (that takes 2 parameters)
> in MS Access that inserts 3 records into a table. I'm using the command
> 'adCmdStoredProc' with the flag 'adExecuteNoRecords'. The command
> executes
> successfully and does not return a recordset pointer.
>
> When I run this through 1000s of iterations for my test, memory usage
> grows
> continuously. If I comment out the Execute() call, memory usage does not
> grow.
>
> The command is setup as follows:
>
> pCmd->put_ActiveConnection(*pConn); // variant
> pCmd->CommandText = szQuery; // name of query/stored proc
> pCmd->CommandType = cmd; // ADODB command id
>
> The actual line of code that executes the command is:
>
> pCmd->Execute(NULL, NULL, cmd | ADODB::adExecuteNoRecords);
>
>
> Any ideas?
>


.

Relevant Pages

  • Re: pymssql - execute loads all results into memory!
    ... is appearing to load all records into memory. ... execute never returns, pythons memory usage slowly ballons till the ... So I am not sure why an execute would feel the need to load all rows, ...
    (comp.lang.python)
  • Re: pymssql - execute loads all results into memory!
    ... is appearing to load all records into memory. ... execute never returns, pythons memory usage slowly ballons till the ... So I am not sure why an execute would feel the need to load all rows, ...
    (comp.lang.python)
  • Re: sqlservr using lots of memory
    ... This seems to be the one eating memory. ... > Can you run the following command from a command prompt to find out the ... > Microsoft Small Business Server Support ... >> All of a sudden my memory usage by sqlservr.exe has shot from 70 to over ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory usage - Evoultion and Mozilla
    ... > When I check the memory usage, with the graphical tools such as KDE ... Using the free command, shows only ...
    (alt.os.linux.suse)
  • Re: Python threading
    ... object (and therefore the memory it uses I assume). ... CoUninitialize releases all system resources held by the COM application, unloads DLLs, and so; it *may* release all COM objects but I'm not sure. ... And, if it will be needed again after a while (when you run the next command), it looks better this way. ... Memory usage grows to 800MB when you invoke each command, but if you wait enough time after the thread finalizes, memory usage goes down to normal. ...
    (comp.lang.python)