I was under the impression that ADO kept things like connection caches (for
connection pooling), cached records and the like in memory, even after they
were closed. Wouldn't that show up as memory used by the host application
for my DLL? Or are these 100% flushed when closing the recordset,
connection, or whatever other objects?
I suspect I have a memory leak in my VB application, which is a data
tier for a SQL Server back-end using ADODB. What I'd like to do, to
the extent possible, is to take ADO's memory usage out of the
equation. In other words, during testing, I'd like to open a
recordset/connection/whatever, then close it again and de-reference
it, and somehow tell ADODB to flush any caches that it's retaining,
de-allocate any buffers it's not using, etc.
No, it's not ADODB that's doing this flushing, it's the VB runtime.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Re: Strange sudden shutdown issue with CF app ... Phone devices are notoriously low on virtual memory right out of the box because the OEMs decide to put every little thing into its own DLL and then have 25 processes launched at boot. ... Chris Tacke, Embedded MVP... We have created an app that basically connects to a web service gets data, then stores it locally on the device, and when a record needs to be modified/added the system first tries to connect the web server sees if its availible, if not then it stores in locally on the device until the connection comes back, now I noticed that if the device does not mess around with the data connection then the application sits nicely as long as its open, and never gets shut down. ... But again most of the time I get no exception at all but just simply disappears. ... (microsoft.public.dotnet.framework.compactframework)
Re: Not enough storage space ... I've tried to close the data source and the session,... When I close the connection, the code I use is this: ... This will actually release the memory or, as I experienced it, ...oledb Application ... (microsoft.public.sqlserver.ce)
Re: Strange sudden shutdown issue with CF app ... Phone devices are notoriously low on virtual memory right out of the box because the OEMs decide to put every little thing into its own DLL and then have 25 processes launched at boot. ... Chris Tacke, Embedded MVP... We have created an app that basically connects to a web service gets data, then stores it locally on the device, and when a record needs to be modified/added the system first tries to connect the web server sees if its availible, if not then it stores in locally on the device until the connection comes back, now I noticed that if the device does not mess around with the data connection then the application sits nicely as long as its open, and never gets shut down. ... But again most of the time I get no exception at all but just simply disappears. ... (microsoft.public.dotnet.framework.compactframework)
Re: Huge memory comsumption of ADODB Connection object ... Why I said the Connection... to nothing, the memory used by my app doesn't decrease, only when I close the ... I take the same opinion as you do, if the cursor doesn't return ... resultset to client, no impact will be imposed to client. ... (microsoft.public.data.ado)
Re: Socket BeginSend and disconnections ... It does depend somewhat on how the connection is broken and where. ... available memory before the network layer can detect the broken ... Is setting the socket buffer to 0 a non-default setting (right now we do not ... sense to catch all exceptions and try to continue gracefully if possible. ... (microsoft.public.dotnet.languages.csharp)
