c# - Enterprise Library Database.ExecuteNonQuery hidden performance issues (Connecting to IBM iSeries) -

I was wondering what was the reason behind the hidden performance of the database object in the Enterprise Library. I have Ondebee Commands (type = archived methodology) which is calling an IBM ISERAS memory process that is being completed 1.5 to 4.5 minutes.

If I manually take approximately 5 seconds for the iSeries device and the same parameter so the performance slowdown is either in the network communications iSeries or hidden within the database object within the enterprise library. Just look for any idea.

  m_asi = DatabaseFactory.CreateDatabase ("ASI-test"); (Var cmd = new OleDbCommand ()) using {cmd.CommandType = CommandType.StoredProcedure; Cmd.CommandText = string.Format ("{0} .P_VNDR_INV", m_strASISprocCatalog); Cmd.Parameters.Add ("@ RUN_ENV", OleDbType.Char, 1) .Value = strenvironmentCode; Cmd.Parameters.Add ("@SIS_KEY", OleDbType.Char, 36) .Value = InvFilter.SISKey; Cmd.Parameters.Add ("@ FROM_DTE", OleDbType.Char, 8) .Value = InvFilter.CheckDateFrom.ToString ("yyyyMMdd"); Cmd.Parameters.Add ("@ TO_DTE", OleDbType.Char, 8) .Value = InvFilter.CheckDateTo.ToString ("yyyyMMdd"); Cmd.Parameters.Add ("@ EXT_Y", OleDbType.Char, 1) .Value = (InvFilter.IsExternal? "Y": "N"); Cmd.Parameters.Add ("@ INC_Y", OleDbType.Char, 1) .Value = (InvFilter.IncludeASI? "Y": "N"); Cmd.Parameters.Add ("@ VND_ID", OleDbType.Char, 1800). Valu = InvFilter.GetVendorQueryString (18, 1800); // This call is blleneck m_asi.ExecuteNonQuery (CMD); }  

I would expect that this would be some strange setting This iSeries tool and. NET is different from the client - for example:

• Transaction mode?
• ansi settings?
• Other connection options? (For SQL Server, I mean things like SET CONCAT_NULL_YIELDS_NULL, etc.)

I do not know much about ISRs, but with SQL Server, for example, this Only "indexed continuously calculated" column if all is well; Otherwise it calculates the formula per line.

Have you tried a trace?