dephi 同时连接mssql 跟oracle9i 事务处理巨慢 求高人指点

Question

//加数据库事务
      dm.ADOConn.CommitTrans;//mssql库
      ADOQ.Close;
//      showmessage('你已成功新建一个客户!');
      except
        dm.ADOConn.RollbackTrans;
        ADOQ.Close;
        exit;
      end;
    dm.ADOConnOrc.BeginTrans;//oracle9i
    try
       with dm.ADOQAdd do
         begin
           if active then
             close;
           sql.Clear;
           sql.Add(SQL_PAT_MASTER);
           prepared;
           active;
           ExecSQL;
         end;
       dm.ADOConnOrc.CommitTrans;
       dm.ADOQAdd.Close;
       showmessage('你已成功新建一个客户!');
    except
        dm.ADOConnOrc.RollbackTrans;
        dm.ADOQAdd.Close;
        exit;
    end;

Answer 1

是oracle操作慢还是mssql慢呢?没明白楼主的意思.

Answer 2

是操作两个数据库，是往oracle里写数据时很慢，日志里有时有失败的事务

Answer 3

是oracle的事务的处理有问题吗