Garbage Collection in .NET?
I have a problem with an app that I have written using the .NET connector version 1.0.4.
The application reads a text file (a line at a time) performing some processing, and then writes the results to the DB.
The problem that I have is that after an amount of processing an acception occurs stating "Unable to connect to any MYSQL host". Monitoring processing using the Connection Health part of MySQL Administrator (version 1.0.18) I can see the Traffic climb to around 800k, and the number of SQL Queries climbs to between 50 and 60.
Initially I thought that I had missed a connection close, but I have walked the code by hand, and also stepped through in debug and am unable to find anything unusual. When I step through using debug mode, all of the connections seem to close promptly with a maximum of 2 queries open at any one time.
I wondering if the app is so busy that garbage collection is not taking place, I have tried inserting calls to Thread.Sleep(0) but this does seem to help.
Any help/thoughts would be much appreciated,
Darren.
Subject
Written By
Posted
Garbage Collection in .NET?
January 26, 2005 11:05AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.