#9 Slow ExecuteNonQuery with binary paramater

open
nobody
None
5
2004-07-14
2004-07-14
Anonymous
No

This ExecuteNonQuery hangs and maxes cpu It is first
noticable at about a 10k file and gets exponentialy
worse. 100k is hardly possible. Any help would be
greatly appreciated.

MySQLConnection conn = new MySQLConnection
( new MySQLConnectionString
( "localhost", "realty", "root", "lifeisok" ).AsString ) ;
MySQLCommand cmd = new MySQLCommand
( "UPDATE user SET " +
"Image = @Image " +
"WHERE UserID = @UserID ",
conn ) ;

cmd.Parameters.Add( new MySQLParameter
( "@UserID", UserID ) ) ;

MySQLParameter blah = new MySQLParameter
( "@Image", DbType.Binary ) ;
blah.Value = Convert.ToBase64String( fileData, 0,
fileData.Length ) ;
cmd.Parameters.Add( blah ) ;

MySQLDataAdapter adapt = new
MySQLDataAdapter( cmd ) ;

conn.Open() ;

retval = cmd.ExecuteNonQuery() ;

conn.Close() ;

Discussion


Log in to post a comment.