code_junkie

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

Nov 14th, 2011
163
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. m_asi = DatabaseFactory.CreateDatabase("ASI-TEST");
  2. using (var cmd = new OleDbCommand())
  3. {
  4. cmd.CommandType = CommandType.StoredProcedure;
  5. cmd.CommandText = string.Format("{0}.P_VNDR_INV", m_strASISprocCatalog);
  6. cmd.Parameters.Add("@RUN_ENV", OleDbType.Char, 1).Value = strEnvironmentCode;
  7. cmd.Parameters.Add("@SIS_KEY", OleDbType.Char, 36).Value = InvFilter.SISKey;
  8. cmd.Parameters.Add("@FROM_DTE", OleDbType.Char, 8).Value = InvFilter.CheckDateFrom.ToString("yyyyMMdd");
  9. cmd.Parameters.Add("@TO_DTE", OleDbType.Char, 8).Value = InvFilter.CheckDateTo.ToString("yyyyMMdd");
  10. cmd.Parameters.Add("@EXT_Y", OleDbType.Char, 1).Value = (InvFilter.IsExternal ? "Y" : "N");
  11. cmd.Parameters.Add("@INC_Y", OleDbType.Char, 1).Value = (InvFilter.IncludeASI ? "Y" : "N");
  12. cmd.Parameters.Add("@VND_ID", OleDbType.Char, 1800).Value = InvFilter.GetVendorQueryString(18, 1800);
  13.  
  14. // This call is the bottleneck
  15. m_asi.ExecuteNonQuery(cmd);
  16. }
Add Comment
Please, Sign In to add comment