Memory leak
Posted: Sun 26 Jul 2009 16:30
Hello,
I just tried out your free ADO.NET Oracle Provider (Express version) and found a serious memory leak.
It really seems to be a bug.
Here's the sample code to reproduce the behaviour (same behaviour with an UPDATE statement instead of the SELECT statement, same behaviour on Windows Server 2008 x64 and Windows XP 32bit).
using(var connection = new OracleConnection("Data Source=XYZ;User Id=system;Password=XYZ"))
{
connection.Open();
for(int i = 0; i < 100000; i++)
{
using (var cmd = connection.CreateCommand())
{
cmd.CommandText = "SELECT 0 AS Dummy FROM dual WHERE 1=0";
cmd.ExecuteNonQuery();
}
}
}
PS: Your contact form and feedback form throw a javascript error...
I just tried out your free ADO.NET Oracle Provider (Express version) and found a serious memory leak.
It really seems to be a bug.
Here's the sample code to reproduce the behaviour (same behaviour with an UPDATE statement instead of the SELECT statement, same behaviour on Windows Server 2008 x64 and Windows XP 32bit).
using(var connection = new OracleConnection("Data Source=XYZ;User Id=system;Password=XYZ"))
{
connection.Open();
for(int i = 0; i < 100000; i++)
{
using (var cmd = connection.CreateCommand())
{
cmd.CommandText = "SELECT 0 AS Dummy FROM dual WHERE 1=0";
cmd.ExecuteNonQuery();
}
}
}
PS: Your contact form and feedback form throw a javascript error...