PS: We cannot acknowledge performance test results, nor can we answer questions or do anything about them -- unless you post your test code including database scripts and platform details.
Cheers,
Clinton
On 10/6/05, Clinton Begin <[EMAIL PROTECTED]> wrote:
If you are seriously worried about 220ms of time in an enterprise aplication, then iBATIS (and all other frameworks) are not for you. Stick with JDBC.
Performance testing enterprise applications is very complex, and you should avoid drawing conclusions based on simple tests of 10 executions of a single SQL statement.
Have you tested Struts compared to plain Servlets and JSP?
Cheers,
ClintonOn 10/5/05, Rodrigo Castillo < [EMAIL PROTECTED]> wrote:Hi,
I built two testing over framwork ibatis, I had used JdbcDaoTemplate and
SqlMapDaoTemplate both implement the same query, the JDBC drivers is oracle.
1) JdbcDaoTemplate
the average of method "execute()" is 80ms (with 10 execution)
2) SqlMapDaoTemplate
the average of method "execute()" is 300ms (with 10 execution) class
com.ibatis.sqlmap.engine.execution.SqlExecutor
why the method execute() of SqlMapDaoTemplate is slower than Jdbc if it is
using the same framework?
----------------------------------------------------------
source JdbcDaoTemplate
----------------------------------------------------------
public class TestingJDBCDAO extends JdbcDaoTemplate implements TestingPLDAO{
public TestingJDBCDAO (DaoManager daoManager) {
super(daoManager);
}
public List findBookingByFlightJDBC(FlightDBO flight) {
Collection result = new ArrayList();
try {
Connection conn = getConnection();
// Llamada a PL para buscar listado de vuelos.
int index = 1;
StringBuffer call = new StringBuffer();
call.append ("select * from book b, vlbk v ");
call.append(" where b.prbk_seq_cdg = v.prbk_seq_cdg ");
call.append(" and v.lnar_cdg_iata=?");
call.append(" and v.vlos_cdg=?");
call.append(" and v.vlos_fch=to_date(?,'dd/mm/yyyy') ");
call.append(" and v.vlbk_origen=?" );
call.append(" and v.vlbk_destino =?" );
// Crear statement y agregarlo a 'closer'.
PreparedStatement cstmt = conn.prepareStatement(call.toString());
// Se Asignan parámetros para el PL.
cstmt.setString ( index++, flight.getIataCode()); // 1
cstmt.setLong(index++, flight.getFlightNumber().longValue()); // 2
SimpleDate fecha = new SimpleDate(flight.getFlightDate());
cstmt.setString (index++, fecha.toString("dd/MM/yyyy") ); // 3
cstmt.setString( index++, flight.getFlightOrigin()); // 4
cstmt.setString( index++, flight.getFlightDestination()); // 5
LapseMeter l= new LapseMeter();
cstmt.execute(); // Ejecuta el PL.
System.out.println("time execute "+l.lapse());
ResultSet rs = cstmt.getResultSet(); // Ejecuta el PL.
// Obtiene cursor con los registros.
BookingDBO booking = null;
while ( rs.next()) {
booking = new BookingDBO();
booking.setBookingCode(new Long(rs.getLong("prbk_seq_cdg")));
booking.setCompanyCode(new Long(rs.getLong("book_empr_cdg")));
booking.setAirlineCode(rs.getString("lnar_cdg_iata"));
booking.setStatus(rs.getString("esbk_cdg_estd"));
booking.setBookingType(rs.getString("tpbk_cdg_booking"));
booking.setDocumentType(rs.getString("tdoc_cdg"));
booking.setUser(rs.getString("book_usuario"));
booking.setUserOffice(rs.getString("book_ofcn_usuario"));
booking.setDocumentOrigin(rs.getString("book_origen_doc"));
booking.setDocumentDestination(rs.getString
("book_destino_doc"));
booking.setFlightOrigin(rs.getString("book_origen_vuelo"));
booking.setFlightDestination(rs.getString
("book_destino_vuelo"));
//booking.setCreationDate( getSimpleDate
(rs,"book_fecha_gen").toDate() );
//booking.setFlightDate( getSimpleDate
(rs,"book_fecha_embarque").toDate() );
booking.setDocumentPrefix(new Long(rs.getLong
("book_pref_doc" )));
booking.setDocumentNumber(new Long(rs.getLong
("book_num_doc" )));
booking.setAgentCode(new Long(rs.getLong("book_clhl_cdg")));
booking.setAgentBranchCode(new Long(rs.getLong
("book_clhl_scrs")));
booking.setAgentContactName(rs.getString
("book_contacto_agente"));
booking.setAgentContactPhone (rs.getString
("book_fono_contacto"));
booking.setShipperCode(new Long(rs.getLong
("book_cdg_shipper")));
booking.setShipperBranchCode(new Long(rs.getLong
("book_scrs_shipper")));
booking.setShipperName(rs.getString("book_nmb_shipper"));
booking.setConsigneeCode(new Long(rs.getLong
("book_cdg_consignee")));
booking.setConsigneeName(rs.getString("book_nmb_consignee"));
booking.setConsigneeBranchCode(new Long(rs.getLong
("book_scrs_consignee")));
booking.setAverageRate(new Double(rs.getDouble("book_tarifa")));
booking.setRemarks(rs.getString("book_remarks"));
booking.setTotalWeight(new Double(rs.getDouble("book_gross")));
booking.setChargeableWeight(new Double(rs.getDouble
("book_chargeable")));
booking.setTotalVolume(new Double(rs.getDouble
("book_volumen_total")));
booking.setTotalPieces(new Long(rs.getLong
("book_total_piezas")));
booking.setAgentName(rs.getString("book_nmb_agente"));
booking.setAgentAcronym(rs.getString("book_acronimo_agente"));
booking.setShipperAcronym(rs.getString
("book_acronimo_shipper"));
booking.setConsigneeAcronym(rs.getString
("book_acronimo_consignee"));
booking.setContractId(rs.getString("cnto_id"));
booking.setContractRateType(rs.getString
("book_contrato_allocation"));
result.add(booking);
}
} catch (Exception x) {
x.printStackTrace();
}
return (List)result;
}
---------------------------------------
Source SqlMapDaoTemplate
---------------------------------------
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map
2.0//EN" " http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="Booking">
<typeAlias alias="flight"
type="com.lan.cargo.laboratorio.persistence.sqlembedded.dbo.FlightDBO "/>
<typeAlias alias="booking"
type="com.lan.cargo.laboratorio.persistence.sqlembedded.dbo.BookingDBO"/>
<resultMap id="bookingResult" class="booking">
<result property="bookingCode" column="prbk_seq_cdg"/>
<result property="companyCode" column="book_empr_cdg" />
<result property="airlineCode" column="lnar_cdg_iata" />
<result property="status" column="esbk_cdg_estd" />
<result property="bookingType" column="tpbk_cdg_booking" />
<result property="documentType" column="tdoc_cdg" />
<result property="user" column="book_usuario" />
<result property="userOffice" column="book_ofcn_usuario" />
<result property="documentOrigin" column="book_origen_doc" />
<result property="documentDestination" column="book_destino_doc" />
<result property="flightOrigin" column="book_origen_vuelo" />
<result property="flightDestination" column="book_destino_vuelo" />
<result property="creationDate" column="book_fecha_gen" />
<result property="flightDate" column="book_fecha_embarque" />
<result property="documentPrefix" column="book_pref_doc" />
<result property="documentNumber" column="book_num_doc" />
<result property="agentCode" column="book_clhl_cdg" />
<result property="agentBranchCode" column="book_clhl_scrs" />
<result property="agentContactName" column="book_contacto_agente" />
<result property="agentContactPhone" column="book_fono_contacto" />
<result property="shipperCode" column="book_cdg_shipper" />
<result property="shipperBranchCode" column="book_scrs_shipper" />
<result property="shipperName" column="book_nmb_shipper" />
<result property="consigneeCode" column="book_cdg_consignee" />
<result property="consigneeName" column="book_nmb_consignee" />
<result property="consigneeBranchCode" column="book_scrs_consignee" />
<result property="averageRate" column="book_tarifa" />
<result property="remarks" column="book_remarks" />
<result property="totalWeight" column="book_gross" />
<result property="chargeableWeight" column="book_chargeable" />
<result property="totalVolume" column="book_volumen_total" />
<result property="totalPieces" column="book_total_piezas" />
<result property="agentName" column="book_nmb_agente" />
<result property="agentAcronym" column="book_acronimo_agente" />
<result property="shipperAcronym" column="book_acronimo_shipper" />
<result property="consigneeAcronym" column="book_acronimo_consignee" />
<result property="contractId" column="cnto_id" />
<result property="contractRateType"
column="book_contrato_allocation" />
</resultMap>
<!--***************************MAPPED
STATEMENTS**************************************-->
<select id="findBookingByFlight" resultMap="bookingResult"
parameterClass="flight" >
select
b.prbk_seq_cdg,
b.book_empr_cdg,
b.lnar_cdg_iata,
b.esbk_cdg_estd,
b.tpbk_cdg_booking,
b.tdoc_cdg,
b.book_usuario,
b.book_ofcn_usuario,
b.book_origen_doc,
b.book_destino_doc,
b.book_origen_vuelo,
b.book_destino_vuelo,
b.book_fecha_gen ,
b.book_fecha_embarque,
b.book_pref_doc,
b.book_num_doc,
b.book_clhl_cdg,
b.book_clhl_scrs,
b.book_contacto_agente,
b.book_acronimo_agente,
b.book_fono_contacto,
b.book_cdg_shipper,
b.book_scrs_shipper,
b.book_nmb_shipper,
b.book_cdg_consignee,
b.book_nmb_consignee ,
b.book_scrs_consignee,
b.book_tarifa,
b.book_remarks,
b.book_gross,
b.book_chargeable,
b.book_volumen_total,
b.book_total_piezas,
b.book_nmb_agente,
b.book_acronimo_shipper,
b.book_acronimo_consignee ,
b.cnto_id,
b.book_contrato_allocation
from book b, vlbk v
where b.prbk_seq_cdg = v.prbk_seq_cdg
and v.lnar_cdg_iata=#iataCode#
and v.vlos_cdg=#flightNumber#
and v.vlos_fch=#flightDate#
and v.vlbk_origen=#flightOrigin#
and v.vlbk_destino =#flightDestination#
</select>
</sqlMap>
------------------------------------------------
source SqlExecutor.java
-----------------------------------------------
errorContext.setMoreInfo("Check the parameters (set parameters
failed).");
request.getParameterMap().setParameters(request, ps, parameters);
errorContext.setMoreInfo("Check the statement (query failed).");
LapseMeter l= new LapseMeter();
ps.execute();
System.out.println("---*** execute "+l.lapse());
rs = ps.getResultSet();
