Re: Long running open connections badly leak memory

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Joerg von Frantzius (joerg.von.frantzius_at_artnology.REMOVE.com)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 11:13:37 +0100
Alin Sinpalean schrieb: 
Joerg von Frantzius wrote:
  
When I close the connections, memory is reclaimed properly. What I
wanted to say is that memory is eaten up indefinitely as long as the
connection *remains open* and is used to repeatedly write large
    
chunks
  
of data into the DB.
    

I understand that. What I meant to say is "are you sure you are
explicitly closing ALL Statements and ResultSets when you're done with
them?". Leaving them open could and will cause the effects you now see.

Alin.
Alright, now I got the point about the Statements and ResultSets, sorry. To be honest, I can't be absolutely sure about that, because I'm relying on a JDO implementation to take care of it.

Relevant Pages

  • Re: Long running open connections badly leak memory
    ... Joerg von Frantzius wrote: ... > When I close the connections, memory is reclaimed properly. ... Alin. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Large virtual memory, small working set
    ... We're basically opening all these connections and receiving data. ... Almost immediately upon starting and loading configuration information, the application starts opening up connections and the memory usage immediately skyrockets. ... The strange thing is - only the virtual memory increases this drastic. ... Is it some sort of side-effect from having that number of open TCP connections that we are stuck with? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Installing RAM and hard drive. Motherboard capabilities?
    ... with SATA, but saw PATA drives. ... connections for hard-drive? ... or is it needed to install stuff to ... It is unlikely you need more RAM/system memory unless you plan to upgrade to ...
    (microsoft.public.windowsxp.hardware)
  • Re: ZX Spectrum - cant get it repaired - help!
    ... Swapped ROM (not 100% usre if that one works, ... o All 4116 RAM's are 100% ok; all connections were checked, ... sound A and after a second or so, it makes sound B and it keeps sound ... It`s been a long time, but I used to repair Spectrums regularly, and what you describe is symptomatic of one of the memory ic`s being faulty, have you tried it with the 32k extension removed? ...
    (sci.electronics.repair)
  • Re: ZONE_NORMAL memory exhausted by 4000 TCP sockets
    ... The problem is the memory. ... concurrent connections, I know the memory size of ZONE_NORMAL would be ... kernel memory allocation might use twice the ram you intend to use because of power of two alignments. ...
    (Linux-Kernel)