ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject RE: poor performance
Date Mon, 28 Jan 2008 18:05:41 GMT
Very weird indeed.  You may need to use a profiler to figure it out.
NetBeans and Eclipse both have free ones.

 

Clinton

 

From: Gerardo Corro Fuentes [mailto:gerardo.corro@mundivia.net] 
Sent: January-28-08 10:40 AM
To: user-java@ibatis.apache.org
Subject: RE: poor performance

 

Hi,

 

-I cut the DTO marshalling part of the code for sake of brevity.

-Marshalling is not the problem since other ibatis DAO functions use the
same DAO and read a lot of data and get results in few seconds

-I used the debug level in order to send you the whole info and get better
help, but it's usually at level INFO

-This is a very weird problem.

 

Thanks!

 

 

  _____  

De: Clinton Begin [mailto:clinton.begin@gmail.com]
Enviado el: lun 28/01/2008 18:36
Para: user-java@ibatis.apache.org
Asunto: RE: poor performance

Oh,

And TURN OFF debugging logging when you do your timings with iBATIS.  The
iBATIS java.sql.* logs are very slow (think method level interceptor that
writes to the console!) and are only intended for debugging purposes.

Clinton 

-----Original Message-----
From: Gerardo Corro Fuentes [mailto:gerardo.corro@mundivia.net]
Sent: January-28-08 10:26 AM
To: user-java@ibatis.apache.org
Subject: RE: poor performance

Hi,

I must download big portions of data, the queries that work properly do that
with no problems at all. Next I'm attaching a JDBC class that retrieves the
data in three seconds, and after that comes the logs that show how ibatis
takes more than two minutes to do the same.

Thanks a lot!!!

package test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.apache.commons.dbcp.BasicDataSource;
import com.mundivia.flumen.db.common.FactoriaSpring;
public class QueryTest {
 public static void main(String args[]) throws SQLException{

 
  BasicDataSource ds = (BasicDataSource)
FactoriaSpring.getApplicationContext().getBean("dataSource");
  Connection con = ds.getConnection();
  Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
    ResultSet.CONCUR_READ_ONLY);
 
  long start = System.currentTimeMillis();
 
 
  ResultSet srs = stmt.executeQuery("SELECT distinct(guid_pm), fecha,
valor_h01, valor_h02, valor_h03, valor_h04, valor_h05, valor_h06, valor_h07,
" +
    "valor_h08, valor_h09, valor_h10, valor_h11, valor_h12, valor_h13,
valor_h14, valor_h15, valor_h16, valor_h17, " +
    "valor_h18, valor_h19, valor_h20, valor_h21, valor_h22, valor_h23,
valor_h24, valor_h25 " +
    "from FLUMEN.vw_puntos_medida_ve vwpm, flumen.variables_periodo vp,
flumen.periodovar p " +
    "where vwpm.id_ccaa = vp.id_sitio " +
    "and substr(vwpm.tarifa, 1, 1) = substr(vp.tarifa, 1, 1) " +
    "and vp.id_var = p.id_var " +
    "and p.fecha >= '20071001' " +
    "and p.fecha <= '20071031' " +
    "AND " +
    "                      ( " +
    "                       vwpm.f_desde_pf <=
to_date('20071001','yyyymmdd') " +
    "                       OR vwpm.f_desde_pf <=
to_date('20071031','yyyymmdd') " +
    "          )    " +                             
    "  AND ( " +
    "              vwpm.f_hasta_pf >= to_date('20071001','yyyymmdd') " +
    "              OR vwpm.f_hasta_pf >= to_date('20071031','yyyymmdd') " +
    "  ) " +
    "  AND ( " +
    "                       vwpm.f_desde_pm <=
to_date('20071001','yyyymmdd') " +
    "                       OR vwpm.f_desde_pm <=
to_date('20071031','yyyymmdd') " +
    "  ) " +
    "  AND ( " +
    "                      vwpm.f_hasta_pm >= to_date('20071001','yyyymmdd')
" +
    "                      OR vwpm.f_hasta_pm >=
to_date('20071031','yyyymmdd') " +
    "  ) " +
    "  AND ( " +
    "                       vwpm.f_desde_cpf <=
to_date('20071001','yyyymmdd') " +
    "                       OR vwpm.f_desde_cpf <=
to_date('20071031','yyyymmdd') " +
    "  ) " +
    " AND( " +
    "                       vwpm.f_hasta_cpf >=
to_date('20071001','yyyymmdd') " +
    "                       OR vwpm.f_hasta_cpf >=
to_date('20071031','yyyymmdd') " +
    " )" +
    "  AND  ( " +
    "                       vwpm.f_desde_apmpf <=
to_date('20071001','yyyymmdd') " +
    "                       OR vwpm.f_desde_apmpf <=
to_date('20071031','yyyymmdd') " +
    " ) " +
    "  AND ( " +
    "                       vwpm.f_hasta_apmpf >=
to_date('20071001','yyyymmdd') " +
    "                       OR vwpm.f_hasta_apmpf >=
to_date('20071031','yyyymmdd') " +
    "  ) " +
    "  AND ( " +
    "                       vwpm.f_desde_cpm <=
to_date('20071001','yyyymmdd') " +
    "                       OR vwpm.f_desde_cpm <=
to_date('20071031','yyyymmdd') " +
    "  ) " +
    "  AND ( " +
    "                       vwpm.f_hasta_cpm >=
to_date('20071001','yyyymmdd') " +
    "                       OR vwpm.f_hasta_cpm >=
to_date('20071031','yyyymmdd') " +
    "  ) " +
    "  AND ( " +
    "                       vwpm.f_desde_cpma <=
to_date('20071001','yyyymmdd') " +
    "                       OR vwpm.f_desde_cpma <=
to_date('20071031','yyyymmdd') " +
    "  ) " +
    "  AND ( " +
    "                       vwpm.f_hasta_cpma >=
to_date('20071001','yyyymmdd') " +
    "                       OR vwpm.f_hasta_cpma >=
to_date('20071031','yyyymmdd') " +
    " ) " +
    " AND ( " +
    "                       vwpm.f_desde_tc <=
to_date('20071001','yyyymmdd') " +
    "                       OR vwpm.f_desde_tc <=
to_date('20071031','yyyymmdd') " +
    "  ) " +
    "  AND ( " +
    "                       vwpm.f_hasta_tc >=
to_date('20071001','yyyymmdd') " +
    "                       OR vwpm.f_hasta_tc >=
to_date('20071031','yyyymmdd') " +
    "  ) " +
  " order by guid_pm, fecha ");
  while (srs.next()) {
   //System.out.print("\nObtengo pm: " + srs.getString(1));
  }
 
  System.out.print("Se tardó: " +  (System.currentTimeMillis()-start));
 }
}


The logs are:

[main] INFO - Loading XML bean definitions from class path resource
[applicationContext-dao.xml]

[main] INFO - Loading XML bean definitions from class path resource
[applicationContext-dao-transacciones.xml]

[main] INFO - Loading XML bean definitions from class path resource
[applicationContext-service.xml]

[main] INFO - Bean factory for application context
[org.springframework.context.support.ClassPathXmlApplicationContext;hashCode
=19475750]:
org.springframework.beans.factory.support.DefaultListableBeanFactory
defining beans
[sqlMapClientTemplate,Prelacion0DAOTarget,Prelacion1DAOTarget,Prelacion2DAOT
arget,Prelacion3DAOTarget,CalculoMVHDAOTarget,Prelacion4DAOTarget,Prelacion6
DAOTarget,Prelacion7DAOTarget,Prelacion8DAOTarget,AltaMVHDAOTarget,propertyC
onfigurer,sqlMapClient,dataSource,Prelacion0DAO,Prelacion1DAO,Prelacion2DAO,
Prelacion3DAO,Prelacion4DAO,Prelacion6DAO,Prelacion7DAO,Prelacion8DAO,Calcul
oMVHDAO,AltaMVHDAO,transactionManager,defaultTxAttributes,Prelacion0Servicio
Target,Prelacion1ServicioTarget,Prelacion2ServicioTarget,Prelacion3ServicioT
arget,CurvaHorariaServicioTarget,Prelacion4ServicioTarget,Prelacion6Servicio
Target,Prelacion7ServicioTarget,Prelacion8ServicioTarget,AltaMVHServicioTarg
et,Prelacion0Servicio,Prelacion1Servicio,Prelacion2Servicio,Prelacion3Servic
io,Prelacion4Servicio,Prelacion6Servicio,Prelacion7Servicio,Prelacion8Servic
io,AltaMVHServicio,CurvaHorariaServicio]; root of BeanFactory hierarchy

[main] INFO - 46 beans defined in application context
[org.springframework.context.support.ClassPathXmlApplicationContext;hashCode
=19475750]

[main] INFO - Creating shared instance of singleton bean
'propertyConfigurer'

[main] INFO - Loading properties from class path resource
[database.properties]

[main] INFO - JDK 1.4+ collections available

[main] INFO - Commons Collections 3.x available

[main] INFO - Unable to locate MessageSource with name 'messageSource':
using default
[org.springframework.context.support.DelegatingMessageSource@82764b]

[main] INFO - Unable to locate ApplicationEventMulticaster with name
'applicationEventMulticaster': using default
[org.springframework.context.event.SimpleApplicationEventMulticaster@1bf3d87
]

[main] INFO - Pre-instantiating singletons in factory
[org.springframework.beans.factory.support.DefaultListableBeanFactory
defining beans
[sqlMapClientTemplate,Prelacion0DAOTarget,Prelacion1DAOTarget,Prelacion2DAOT
arget,Prelacion3DAOTarget,CalculoMVHDAOTarget,Prelacion4DAOTarget,Prelacion6
DAOTarget,Prelacion7DAOTarget,Prelacion8DAOTarget,AltaMVHDAOTarget,propertyC
onfigurer,sqlMapClient,dataSource,Prelacion0DAO,Prelacion1DAO,Prelacion2DAO,
Prelacion3DAO,Prelacion4DAO,Prelacion6DAO,Prelacion7DAO,Prelacion8DAO,Calcul
oMVHDAO,AltaMVHDAO,transactionManager,defaultTxAttributes,Prelacion0Servicio
Target,Prelacion1ServicioTarget,Prelacion2ServicioTarget,Prelacion3ServicioT
arget,CurvaHorariaServicioTarget,Prelacion4ServicioTarget,Prelacion6Servicio
Target,Prelacion7ServicioTarget,Prelacion8ServicioTarget,AltaMVHServicioTarg
et,Prelacion0Servicio,Prelacion1Servicio,Prelacion2Servicio,Prelacion3Servic
io,Prelacion4Servicio,Prelacion6Servicio,Prelacion7Servicio,Prelacion8Servic
io,AltaMVHServicio,CurvaHorariaServicio]; root of BeanFactory hierarchy]

[main] INFO - Creating shared instance of singleton bean
'sqlMapClientTemplate'

[main] INFO - Creating shared instance of singleton bean 'sqlMapClient'

[main] INFO - Creating shared instance of singleton bean 'dataSource'

[main] INFO - Creating shared instance of singleton bean
'Prelacion0DAOTarget'

[main] INFO - Creating shared instance of singleton bean
'Prelacion1DAOTarget'

[main] INFO - Creating shared instance of singleton bean
'Prelacion2DAOTarget'

[main] INFO - Creating shared instance of singleton bean
'Prelacion3DAOTarget'

[main] INFO - Creating shared instance of singleton bean
'CalculoMVHDAOTarget'

[main] INFO - Creating shared instance of singleton bean
'Prelacion4DAOTarget'

[main] INFO - Creating shared instance of singleton bean
'Prelacion6DAOTarget'

[main] INFO - Creating shared instance of singleton bean
'Prelacion7DAOTarget'

[main] INFO - Creating shared instance of singleton bean
'Prelacion8DAOTarget'

[main] INFO - Creating shared instance of singleton bean 'AltaMVHDAOTarget'

[main] INFO - Creating shared instance of singleton bean 'Prelacion0DAO'

[main] INFO - CGLIB2 not available: proxyTargetClass feature disabled

[main] INFO - Creating shared instance of singleton bean
'transactionManager'

[main] INFO - Creating shared instance of singleton bean
'defaultTxAttributes'

[main] INFO - Creating shared instance of singleton bean 'Prelacion1DAO'

[main] INFO - Creating shared instance of singleton bean 'Prelacion2DAO'

[main] INFO - Creating shared instance of singleton bean 'Prelacion3DAO'

[main] INFO - Creating shared instance of singleton bean 'Prelacion4DAO'

[main] INFO - Creating shared instance of singleton bean 'Prelacion6DAO'

[main] INFO - Creating shared instance of singleton bean 'Prelacion7DAO'

[main] INFO - Creating shared instance of singleton bean 'Prelacion8DAO'

[main] INFO - Creating shared instance of singleton bean 'CalculoMVHDAO'

[main] INFO - Creating shared instance of singleton bean 'AltaMVHDAO'

[main] INFO - Creating shared instance of singleton bean
'Prelacion0Servicio'

[main] INFO - Creating shared instance of singleton bean
'Prelacion1Servicio'

[main] INFO - Creating shared instance of singleton bean
'Prelacion2Servicio'

[main] INFO - Creating shared instance of singleton bean
'Prelacion3Servicio'

[main] INFO - Creating shared instance of singleton bean
'Prelacion4Servicio'

[main] INFO - Creating shared instance of singleton bean
'Prelacion6Servicio'

[main] INFO - Creating shared instance of singleton bean
'Prelacion7Servicio'

[main] INFO - Creating shared instance of singleton bean
'Prelacion8Servicio'

[main] INFO - Creating shared instance of singleton bean 'AltaMVHServicio'

[main] INFO - Creating shared instance of singleton bean
'CurvaHorariaServicio'

[main] INFO - JDBC 3.0 Savepoint class is available

[main] DEBUG - Using transaction object
[org.springframework.jdbc.datasource.DataSourceTransactionManager$DataSource
TransactionObject@187c55c]

[main] INFO - Prelacion1ServicioImpl:buscarPrelacion0 ...se van a buscar los
datos para prelacion 0

[main] DEBUG - Using transaction object
[org.springframework.jdbc.datasource.DataSourceTransactionManager$DataSource
TransactionObject@b02928]

[main] DEBUG - Executing action directly on SqlMapClient

[main] DEBUG - Opening JDBC Connection

[main] DEBUG - Registering transaction synchronization for JDBC Connection

[main] DEBUG - {conn-100000} Connection

[main] DEBUG - {conn-100000} Preparing Statement: select distinct(guid_pm)
from FLUMEN.vw_puntos_medida_ve vwpm WHERE ( vwpm.f_desde_pf <=
to_date(?,'yyyymmdd') OR vwpm.f_desde_pf <= to_date(?,'yyyymmdd') ) AND (
vwpm.f_hasta_pf >= to_date(?,'yyyymmdd') OR vwpm.f_hasta_pf >=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_pm <= to_date(?,'yyyymmdd') OR
vwpm.f_desde_pm <= to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_pm >=
to_date(?,'yyyymmdd') OR vwpm.f_hasta_pm >= to_date(?,'yyyymmdd') ) AND (
vwpm.f_desde_cpf <= to_date(?,'yyyymmdd') OR vwpm.f_desde_cpf <=
to_date(?,'yyyymmdd') ) AND( vwpm.f_hasta_cpf >= to_date(?,'yyyymmdd') OR
vwpm.f_hasta_cpf >= to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_apmpf <=
to_date(?,'yyyymmdd') OR vwpm.f_desde_apmpf <= to_date(?,'yyyymmdd') ) AND (
vwpm.f_hasta_apmpf >= to_date(?,'yyyymmdd') OR vwpm.f_hasta_apmpf >=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_cpm <= to_date(?,'yyyymmdd') OR
vwpm.f_desde_cpm <= to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_cpm >=
to_date(?,'yyyymmdd') OR vwpm.f_hasta_cpm >= to_date(?,'yyyymmdd') ) AND (
vwpm.f_desde_cpma <= to_date(?,'yyyymmdd') OR vwpm.f_desde_cpma <=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_cpma >= to_date(?,'yyyymmdd') OR
vwpm.f_hasta_cpma >= to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_tc <=
to_date(?,'yyyymmdd') OR vwpm.f_desde_tc <= to_date(?,'yyyymmdd') ) AND (
vwpm.f_hasta_tc >= to_date(?,'yyyymmdd') OR vwpm.f_hasta_tc >=
to_date(?,'yyyymmdd') )

[main] DEBUG - {pstm-100001} Executing Statement: select distinct(guid_pm)
from FLUMEN.vw_puntos_medida_ve vwpm WHERE ( vwpm.f_desde_pf <=
to_date(?,'yyyymmdd') OR vwpm.f_desde_pf <= to_date(?,'yyyymmdd') ) AND (
vwpm.f_hasta_pf >= to_date(?,'yyyymmdd') OR vwpm.f_hasta_pf >=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_pm <= to_date(?,'yyyymmdd') OR
vwpm.f_desde_pm <= to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_pm >=
to_date(?,'yyyymmdd') OR vwpm.f_hasta_pm >= to_date(?,'yyyymmdd') ) AND (
vwpm.f_desde_cpf <= to_date(?,'yyyymmdd') OR vwpm.f_desde_cpf <=
to_date(?,'yyyymmdd') ) AND( vwpm.f_hasta_cpf >= to_date(?,'yyyymmdd') OR
vwpm.f_hasta_cpf >= to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_apmpf <=
to_date(?,'yyyymmdd') OR vwpm.f_desde_apmpf <= to_date(?,'yyyymmdd') ) AND (
vwpm.f_hasta_apmpf >= to_date(?,'yyyymmdd') OR vwpm.f_hasta_apmpf >=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_cpm <= to_date(?,'yyyymmdd') OR
vwpm.f_desde_cpm <= to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_cpm >=
to_date(?,'yyyymmdd') OR vwpm.f_hasta_cpm >= to_date(?,'yyyymmdd') ) AND (
vwpm.f_desde_cpma <= to_date(?,'yyyymmdd') OR vwpm.f_desde_cpma <=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_cpma >= to_date(?,'yyyymmdd') OR
vwpm.f_hasta_cpma >= to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_tc <=
to_date(?,'yyyymmdd') OR vwpm.f_desde_tc <= to_date(?,'yyyymmdd') ) AND (
vwpm.f_hasta_tc >= to_date(?,'yyyymmdd') OR vwpm.f_hasta_tc >=
to_date(?,'yyyymmdd') )

[main] DEBUG - {pstm-100001} Parameters: [20071001, 20071030, 20071001,
20071030, 20071001, 20071030, 20071001, 20071030, 20071001, 20071030,
20071001, 20071030, 20071001, 20071030, 20071001, 20071030, 20071001,
20071030, 20071001, 20071030, 20071001, 20071030, 20071001, 20071030,
20071001, 20071030, 20071001, 20071030]

[main] DEBUG - {pstm-100001} Types: [java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String,
java.lang.String, java.lang.String]

[main] DEBUG - {rset-100002} ResultSet

[main] DEBUG - {rset-100002} Header: [GUID_PM]

[main] DEBUG - {rset-100002} Result: [7322]

[main] DEBUG - {rset-100002} Result: [7305]

[main] DEBUG - {rset-100002} Result: [1270102]

[main] DEBUG - {rset-100002} Result: [7298]

[main] DEBUG - {rset-100002} Result: [1284195]

[main] DEBUG - {rset-100002} Result: [1285724]

[main] DEBUG - {rset-100002} Result: [7539]

[main] DEBUG - {rset-100002} Result: [1309723]

[main] DEBUG - {rset-100002} Result: [1285091]

[main] DEBUG - {rset-100002} Result: [1323673]

[main] DEBUG - {rset-100002} Result: [1284043]

[main] DEBUG - {rset-100002} Result: [1283520]

[main] DEBUG - {rset-100002} Result: [38286]

[main] DEBUG - {rset-100002} Result: [1297556]

[main] DEBUG - {rset-100002} Result: [7542]

[main] DEBUG - {rset-100002} Result: [49352]

[main] DEBUG - {rset-100002} Result: [1305525]

[main] DEBUG - {rset-100002} Result: [1317347]

[main] DEBUG - {rset-100002} Result: [1297637]

[main] DEBUG - {rset-100002} Result: [1314151]

[main] DEBUG - {rset-100002} Result: [1324687]

[main] DEBUG - {rset-100002} Result: [1297583]

[main] DEBUG - {rset-100002} Result: [1297565]

[main] DEBUG - {rset-100002} Result: [1270186]

[main] DEBUG - {rset-100002} Result: [7300]

[main] DEBUG - {rset-100002} Result: [7294]

[main] DEBUG - {rset-100002} Result: [1314597]

[main] DEBUG - {rset-100002} Result: [1297855]

[main] DEBUG - {rset-100002} Result: [1314514]

[main] DEBUG - {rset-100002} Result: [1297619]

[main] DEBUG - {rset-100002} Result: [1305437]

[main] DEBUG - {rset-100002} Result: [1297437]

[main] DEBUG - {rset-100002} Result: [54124]

[main] DEBUG - {rset-100002} Result: [1306645]

[main] DEBUG - {rset-100002} Result: [1184876]

[main] DEBUG - {rset-100002} Result: [57808]

[main] DEBUG - {rset-100002} Result: [7471]

[main] DEBUG - {rset-100002} Result: [7520]

[main] DEBUG - {rset-100002} Result: [1322275]

[main] DEBUG - {rset-100002} Result: [1312879]

[main] DEBUG - {rset-100002} Result: [1312870]

[main] DEBUG - {rset-100002} Result: [1297497]

[main] DEBUG - {rset-100002} Result: [1297574]

[main] DEBUG - {rset-100002} Result: [1287044]

[main] DEBUG - {rset-100002} Result: [1314133]

[main] DEBUG - {rset-100002} Result: [1309732]

[main] DEBUG - {rset-100002} Result: [1314169]

[main] DEBUG - {rset-100002} Result: [58574]

[main] DEBUG - {rset-100002} Result: [1285781]

[main] DEBUG - {rset-100002} Result: [1297646]

[main] DEBUG - {rset-100002} Result: [7519]

[main] DEBUG - {rset-100002} Result: [1198695]

[main] DEBUG - {rset-100002} Result: [1306636]

[main] DEBUG - {rset-100002} Result: [48449]

[main] DEBUG - {rset-100002} Result: [1297628]

[main] DEBUG - {rset-100002} Result: [7522]

[main] DEBUG - {rset-100002} Result: [48738]

[main] DEBUG - {rset-100002} Result: [1270084]

[main] DEBUG - {rset-100002} Result: [1297419]

[main] DEBUG - {rset-100002} Result: [1314615]

[main] DEBUG - {rset-100002} Result: [1314606]

[main] DEBUG - {rset-100002} Result: [1313946]

[main] DEBUG - {rset-100002} Result: [1331045]

[main] DEBUG - {rset-100002} Result: [7469]

[main] DEBUG - {rset-100002} Result: [7283]

[main] DEBUG - {rset-100002} Result: [1297713]

[main] DEBUG - {rset-100002} Result: [1314550]

[main] DEBUG - {rset-100002} Result: [1324705]

[main] DEBUG - {rset-100002} Result: [1324669]

[main] DEBUG - {rset-100002} Result: [58584]

[main] DEBUG - {rset-100002} Result: [1305265]

[main] DEBUG - {rset-100002} Result: [1297683]

[main] DEBUG - {rset-100002} Result: [1312915]

[main] DEBUG - {rset-100002} Result: [1314142]

[main] DEBUG - {rset-100002} Result: [1297704]

[main] DEBUG - {rset-100002} Result: [1298358]

[main] DEBUG - {rset-100002} Result: [1297488]

[main] DEBUG - {rset-100002} Result: [1314541]

[main] DEBUG - {rset-100002} Result: [1324678]

[main] DEBUG - {rset-100002} Result: [57836]

[main] DEBUG - {rset-100002} Result: [57843]

[main] DEBUG - {rset-100002} Result: [1283553]

[main] DEBUG - {rset-100002} Result: [1286950]

[main] DEBUG - {rset-100002} Result: [7326]

[main] DEBUG - {rset-100002} Result: [7308]

[main] DEBUG - {rset-100002} Result: [1283436]

[main] DEBUG - {rset-100002} Result: [1285149]

[main] DEBUG - {rset-100002} Result: [1324273]

[main] DEBUG - {rset-100002} Result: [1285837]

[main] DEBUG - {rset-100002} Result: [1305880]

[main] DEBUG - {rset-100002} Result: [1204464]

[main] DEBUG - {rset-100002} Result: [7521]

[main] DEBUG - {rset-100002} Result: [7285]

[main] DEBUG - {rset-100002} Result: [1314523]

[main] DEBUG - {rset-100002} Result: [1314160]

[main] DEBUG - {rset-100002} Result: [1306244]

[main] DEBUG - {rset-100002} Result: [1296858]

[main] DEBUG - {rset-100002} Result: [48429]

[main] DEBUG - {rset-100002} Result: [1306169]

[main] DEBUG - {rset-100002} Result: [1285695]

[main] DEBUG - {rset-100002} Result: [1305274]

[main] DEBUG - {rset-100002} Result: [1306474]

[main] DEBUG - {rset-100002} Result: [6889]

[main] DEBUG - {rset-100002} Result: [1319257]

[main] DEBUG - {rset-100002} Result: [1324696]

[main] DEBUG - {rset-100002} Result: [7320]

[main] DEBUG - {rset-100002} Result: [1297524]

[main] DEBUG - {rset-100002} Result: [1270156]

[main] DEBUG - {rset-100002} Result: [7553]

[main] DEBUG - {rset-100002} Result: [1305552]

[main] DEBUG - {rset-100002} Result: [6877]

[main] DEBUG - {rset-100002} Result: [1195746]

[main] DEBUG - {rset-100002} Result: [26265]

[main] DEBUG - {rset-100002} Result: [1314178]

[main] DEBUG - {rset-100002} Result: [1314851]

[main] DEBUG - {rset-100002} Result: [1312906]

[main] DEBUG - {rset-100002} Result: [54089]

[main] DEBUG - {rset-100002} Result: [6871]

[main] DEBUG - {rset-100002} Result: [48388]

[main] DEBUG - {rset-100002} Result: [1324723]

[main] DEBUG - {rset-100002} Result: [1312897]

[main] DEBUG - {rset-100002} Result: [1285503]

[main] DEBUG - {rset-100002} Result: [1314633]

[main] DEBUG - {rset-100002} Result: [1306160]

[main] DEBUG - {rset-100002} Result: [1198656]

[main] DEBUG - {rset-100002} Result: [1297695]

[main] DEBUG - {rset-100002} Result: [7307]

[main] DEBUG - {rset-100002} Result: [1285850]

[main] DEBUG - {rset-100002} Result: [1198704]

[main] DEBUG - {rset-100002} Result: [1312888]

[main] DEBUG - {rset-100002} Result: [1296918]

[main] DEBUG - {rset-100002} Result: [1305534]

[main] DEBUG - {rset-100002} Result: [1312993]

[main] DEBUG - {rset-100002} Result: [1285533]

[main] DEBUG - {rset-100002} Result: [1270138]

[main] DEBUG - {rset-100002} Result: [1319282]

[main] DEBUG - {rset-100002} Result: [7290]

[main] DEBUG - {rset-100002} Result: [7289]

[main] DEBUG - {rset-100002} Result: [38291]

[main] DEBUG - {rset-100002} Result: [7541]

[main] DEBUG - {rset-100002} Result: [7287]

[main] DEBUG - {rset-100002} Result: [7284]

[main] DEBUG - {rset-100002} Result: [1297610]

[main] DEBUG - {rset-100002} Result: [1314532]

[main] DEBUG - {rset-100002} Result: [6981]

[main] DEBUG - {rset-100002} Result: [1324714]

[main] DEBUG - {rset-100002} Result: [1305650]

[main] DEBUG - {rset-100002} Result: [1312933]

[main] DEBUG - {rset-100002} Result: [48439]

[main] DEBUG - {rset-100002} Result: [1022538]

[main] DEBUG - {rset-100002} Result: [1285512]

[main] DEBUG - {rset-100002} Result: [1024146]

[main] DEBUG - {rset-100002} Result: [1024231]

[main] DEBUG - {rset-100002} Result: [1306483]

[main] DEBUG - {rset-100002} Result: [1285521]

[main] DEBUG - {rset-100002} Result: [1285862]

[main] DEBUG - {rset-100002} Result: [7327]

[main] DEBUG - {rset-100002} Result: [7301]

[main] DEBUG - {rset-100002} Result: [45626]

[main] DEBUG - {rset-100002} Result: [1314496]

[main] DEBUG - {rset-100002} Result: [1306253]

[main] DEBUG - {rset-100002} Result: [1285661]

[main] DEBUG - {rset-100002} Result: [1297601]

[main] DEBUG - {rset-100002} Result: [1314505]

[main] DEBUG - {rset-100002} Result: [1309714]

[main] DEBUG - {rset-100002} Result: [1305871]

[main] DEBUG - {rset-100002} Result: [1283382]

[main] DEBUG - {rset-100002} Result: [1324282]

[main] DEBUG - {rset-100002} Result: [1283403]

[main] DEBUG - {rset-100002} Result: [7288]

[main] DEBUG - {rset-100002} Result: [1284896]

[main] DEBUG - {rset-100002} Result: [1305862]

[main] DEBUG - {rset-100002} Result: [1312924]

[main] DEBUG - {rset-100002} Result: [1313005]

[main] DEBUG - {rset-100002} Result: [1198679]

[main] DEBUG - {rset-100002} Result: [1317239]

[main] DEBUG - {rset-100002} Result: [45565]

[main] DEBUG - {rset-100002} Result: [1296867]

[main] DEBUG - {rset-100002} Result: [49382]

[main] DEBUG - {rset-100002} Result: [1324264]

[main] DEBUG - {rset-100002} Result: [1294962]

[main] DEBUG - {rset-100002} Result: [1317338]

[main] DEBUG - {rset-100002} Result: [1314624]

[main] DEBUG - {rset-100002} Result: [38296]

[main] DEBUG - {rset-100002} Result: [7306]

[main] DEBUG - {rset-100002} Result: [1270120]

[main] DEBUG - {rset-100002} Result: [1321174]

[main] DEBUG - {rset-100002} Result: [1270198]

[main] DEBUG - {rset-100002} Result: [1283364]

[main] DEBUG - {rset-100002} Result: [7316]

[main] DEBUG - {rset-100002} Result: [7302]

[main] DEBUG - {rset-100002} Result: [7295]

[main] DEBUG - {rset-100002} Result: [6876]

[main] DEBUG - {rset-100002} Result: [26260]

[main] DEBUG - {rset-100002} Result: [1297674]

[main] DEBUG - {rset-100002} Result: [1196863]

[main] DEBUG - {rset-100002} Result: [1314735]

[main] DEBUG - {rset-100002} Result: [1285736]

[main] DEBUG - {rset-100002} Result: [1297428]

[main] DEBUG - {rset-100002} Result: [1195730]

[main] DEBUG - {rset-100002} Result: [1297365]

[main] DEBUG - {rset-100002} Result: [1293213]

[main] DEBUG - {rset-100002} Result: [1324294]

[main] DEBUG - {rset-100002} Result: [1324255]

[main] DEBUG - {rset-100002} Result: [1297547]

[main] DEBUG - {rset-100002} Result: [1305453]

[main] DEBUG - {rset-100002} Result: [7540]

[main] DEBUG - {rset-100002} Result: [1285359]

[main] DEBUG - {rset-100002} Result: [1283583]

[main] DEBUG - {rset-100002} Result: [1305543]

[main] DEBUG - {rset-100002} Result: [1297506]

[main] DEBUG - {rset-100002} Result: [1297592]

[main] DEBUG - {rset-100002} Result: [1022555]

[main] DEBUG - {rset-100002} Result: [58564]

[main] DEBUG - {rset-100002} Result: [1284878]

[main] DEBUG - {rset-100002} Result: [1306151]

[main] DEBUG - Triggering beforeCommit synchronization

[main] DEBUG - Triggering beforeCompletion synchronization

[main] DEBUG - Closing JDBC Connection

[main] DEBUG - Triggering afterCompletion synchronization

[main] DEBUG - Using transaction object
[org.springframework.jdbc.datasource.DataSourceTransactionManager$DataSource
TransactionObject@221e9e]

[main] INFO - Prelacion1ServicioImpl:buscarPrelacion0 ...se van a buscar los
datos para prelacion 0

[main] DEBUG - Using transaction object
[org.springframework.jdbc.datasource.DataSourceTransactionManager$DataSource
TransactionObject@1264eab]

[main] DEBUG - Executing action directly on SqlMapClient

[main] DEBUG - Opening JDBC Connection

[main] DEBUG - Registering transaction synchronization for JDBC Connection

[main] DEBUG - {conn-100003} Connection

[main] DEBUG - {conn-100003} Preparing Statement: SELECT distinct(guid_pm),
fecha, valor_h01, valor_h02, valor_h03, valor_h04, valor_h05, valor_h06,
valor_h07, valor_h08, valor_h09, valor_h10, valor_h11, valor_h12, valor_h13,
valor_h14, valor_h15, valor_h16, valor_h17, valor_h18, valor_h19, valor_h20,
valor_h21, valor_h22, valor_h23, valor_h24, valor_h25 from
FLUMEN.vw_puntos_medida_ve vwpm, flumen.variables_periodo vp,
flumen.periodovar p where vwpm.id_ccaa = vp.id_sitio and substr(vwpm.tarifa,
1, 1) = substr(vp.tarifa, 1, 1) and vp.id_var = p.id_var and p.fecha >= ?
and p.fecha <= ? AND ( vwpm.f_desde_pf <= to_date(?,'yyyymmdd') OR
vwpm.f_desde_pf <= to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_pf >=
to_date(?,'yyyymmdd') OR vwpm.f_hasta_pf >= to_date(?,'yyyymmdd') ) AND (
vwpm.f_desde_pm <= to_date(?,'yyyymmdd') OR vwpm.f_desde_pm <=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_pm >= to_date(?,'yyyymmdd') OR
vwpm.f_hasta_pm >= to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_cpf <=
to_date(?,'yyyymmdd') OR vwpm.f_desde_cpf <= to_date(?,'yyyymmdd') ) AND(
vwpm.f_hasta_cpf >= to_date(?,'yyyymmdd') OR vwpm.f_hasta_cpf >=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_apmpf <= to_date(?,'yyyymmdd') OR
vwpm.f_desde_apmpf <= to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_apmpf >=
to_date(?,'yyyymmdd') OR vwpm.f_hasta_apmpf >= to_date(?,'yyyymmdd') ) AND (
vwpm.f_desde_cpm <= to_date(?,'yyyymmdd') OR vwpm.f_desde_cpm <=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_cpm >= to_date(?,'yyyymmdd') OR
vwpm.f_hasta_cpm >= to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_cpma <=
to_date(?,'yyyymmdd') OR vwpm.f_desde_cpma <= to_date(?,'yyyymmdd') ) AND (
vwpm.f_hasta_cpma >= to_date(?,'yyyymmdd') OR vwpm.f_hasta_cpma >=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_tc <= to_date(?,'yyyymmdd') OR
vwpm.f_desde_tc <= to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_tc >=
to_date(?,'yyyymmdd') OR vwpm.f_hasta_tc >= to_date(?,'yyyymmdd') ) order by
guid_pm, fecha

[main] DEBUG - {pstm-100004} Executing Statement: SELECT distinct(guid_pm),
fecha, valor_h01, valor_h02, valor_h03, valor_h04, valor_h05, valor_h06,
valor_h07, valor_h08, valor_h09, valor_h10, valor_h11, valor_h12, valor_h13,
valor_h14, valor_h15, valor_h16, valor_h17, valor_h18, valor_h19, valor_h20,
valor_h21, valor_h22, valor_h23, valor_h24, valor_h25 from
FLUMEN.vw_puntos_medida_ve vwpm, flumen.variables_periodo vp,
flumen.periodovar p where vwpm.id_ccaa = vp.id_sitio and substr(vwpm.tarifa,
1, 1) = substr(vp.tarifa, 1, 1) and vp.id_var = p.id_var and p.fecha >= ?
and p.fecha <= ? AND ( vwpm.f_desde_pf <= to_date(?,'yyyymmdd') OR
vwpm.f_desde_pf <= to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_pf >=
to_date(?,'yyyymmdd') OR vwpm.f_hasta_pf >= to_date(?,'yyyymmdd') ) AND (
vwpm.f_desde_pm <= to_date(?,'yyyymmdd') OR vwpm.f_desde_pm <=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_pm >= to_date(?,'yyyymmdd') OR
vwpm.f_hasta_pm >= to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_cpf <=
to_date(?,'yyyymmdd') OR vwpm.f_desde_cpf <= to_date(?,'yyyymmdd') ) AND(
vwpm.f_hasta_cpf >= to_date(?,'yyyymmdd') OR vwpm.f_hasta_cpf >=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_apmpf <= to_date(?,'yyyymmdd') OR
vwpm.f_desde_apmpf <= to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_apmpf >=
to_date(?,'yyyymmdd') OR vwpm.f_hasta_apmpf >= to_date(?,'yyyymmdd') ) AND (
vwpm.f_desde_cpm <= to_date(?,'yyyymmdd') OR vwpm.f_desde_cpm <=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_cpm >= to_date(?,'yyyymmdd') OR
vwpm.f_hasta_cpm >= to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_cpma <=
to_date(?,'yyyymmdd') OR vwpm.f_desde_cpma <= to_date(?,'yyyymmdd') ) AND (
vwpm.f_hasta_cpma >= to_date(?,'yyyymmdd') OR vwpm.f_hasta_cpma >=
to_date(?,'yyyymmdd') ) AND ( vwpm.f_desde_tc <= to_date(?,'yyyymmdd') OR
vwpm.f_desde_tc <= to_date(?,'yyyymmdd') ) AND ( vwpm.f_hasta_tc >=
to_date(?,'yyyymmdd') OR vwpm.f_hasta_tc >= to_date(?,'yyyymmdd') ) order by
guid_pm, fecha

[main] DEBUG - {pstm-100004} Parameters: [20071001, 20071030, 20071001,
20071030, 20071001, 20071030, 20071001, 20071030, 20071001, 20071030,
20071001, 20071030, 20071001, 20071030, 20071001, 20071030, 20071001,
20071030, 20071001, 20071030, 20071001, 20071030, 20071001, 20071030,
20071001, 20071030, 20071001, 20071030, 20071001, 20071030]

[main] DEBUG - {pstm-100004} Types: [java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String]

[main] DEBUG - {rset-100005} ResultSet

[main] DEBUG - {rset-100005} Header: [guid_pm, fecha, valor_h01, valor_h02,
valor_h03, valor_h04, valor_h05, valor_h06, valor_h07, valor_h08, valor_h09,
valor_h10, valor_h11, valor_h12, valor_h13, valor_h14, valor_h15, valor_h16,
valor_h17, valor_h18, valor_h19, valor_h20, valor_h21, valor_h22, valor_h23,
valor_h24, valor_h25]

[main] DEBUG - {rset-100005} Result: [6871, 20071001, 6, 6, 6, 6, 6, 6, 6,
6, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 6, 5, 5, 5, 5, null]

[main] DEBUG - {rset-100005} Result: [6871, 20071002, 6, 6, 6, 6, 6, 6, 6,
6, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 6, 5, 5, 5, 5, null]

[main] DEBUG - {rset-100005} Result: [6871, 20071003, 6, 6, 6, 6, 6, 6, 6,
6, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 6, 5, 5, 5, 5, null]



... many more rows here....



[main] DEBUG - {rset-100005} Result: [1331045, 20071027, 6, 6, 6, 6, 6, 6,
6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, null]

[main] DEBUG - {rset-100005} Result: [1331045, 20071028, 6, 6, 6, 6, 6, 6,
6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, null]

[main] DEBUG - {rset-100005} Result: [1331045, 20071029, 6, 6, 6, 6, 6, 6,
6, 6, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 6, 5, 5, 5, 5, null]

[main] DEBUG - {rset-100005} Result: [1331045, 20071030, 6, 6, 6, 6, 6, 6,
6, 6, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 6, 5, 5, 5, 5, null]

[main] DEBUG - Triggering beforeCommit synchronization

[main] DEBUG - Triggering beforeCompletion synchronization

[main] DEBUG - Closing JDBC Connection

[main] DEBUG - Triggering afterCompletion synchronization

[main] INFO - All data was retrieved in: 148278ms


________________________________

De: Randall Svancara [mailto:rsvancara@wsu.edu]
Enviado el: lun 28/01/2008 18:05
Para: user-java@ibatis.apache.org
Asunto: Re: poor performance



Turn on debugging and send the output.  Also send the queries if you can
so that we know what you are trying to query within reason of course.

Also make sure you are querying the same database as you are querying in
with your jdbc driver.  Also make sure you are using query properly,
hitting the indexes and such.

Also, if you are returning back large record sets, consider returning
back smaller record sets, and if you can't, try using paginated results.

I know this some of this seems rudimentary, but let's get rid of the
obvious problems first.

-
Randall Svancara


On Mon, 2008-01-28 at 17:56 +0100, Gerardo Corro Fuentes wrote:
> Hi,
>
> I built a DAO with IBatis 2.2.0. Most of this DAO works properly,
> however thre are a couple of queries that are very slow, it takes 2
> minutes for them to be completed while a plain JDBC querie takes only
> three seconds.
>
> I verified the slow quieries many times, and they actually look very
> similar to others that run very fast.
>
> I also Spring 1.2; commons DBCP 1.4.
>
> Thanks!!!
>
>
>
> The ibatis config file looks like:
>
> <settings
>
> cacheModelsEnabled="false"
>
> enhancementEnabled="true"
>
> maxSessions="64"
>
> maxTransactions="8"
>
> maxRequests="128"
>
> useStatementNamespaces="true"/>
>
>
>
>
>
>
>
>
>
>
>
> <?sml version="1.0" encoding="UTF-8" ?>
>
> <!DOCTYPE sqlMap
>
> PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
>
> "http://www.ibatis.com/dtd/sql-map-2.dtd">
>
> <sqlMap namespace="CurvaHoraria">
>
> <typeAlias alias="curvaHoraria" type="com.db.dto.DTO1"/>
>
> <resultMap id="curvaHorariaResult" class="curvaHoraria">
>
> <result property="guidPm" column="guid_pm"/>
>
> <result property="fecha" column="fecha"/>
>
> <result property="periodo1" column="valor_h01"/>
>
> <result property="periodo2" column="valor_h02"/>
>
> <result property="periodo3" column="valor_h03"/>
>
> <result property="periodo4" column="valor_h04"/>
>
> <result property="periodo5" column="valor_h05"/>
>
> <result property="periodo6" column="valor_h06"/>
>
> <result property="periodo7" column="valor_h07"/>
>
> <result property="periodo8" column="valor_h08"/>
>
> <result property="periodo9" column="valor_h09"/>
>
> <result property="periodo10" column="valor_h10"/>
>
> <result property="periodo11" column="valor_h11"/>
>
> <result property="periodo12" column="valor_h12"/>
>
> <result property="periodo13" column="valor_h13"/>
>
> <result property="periodo14" column="valor_h14"/>
>
> <result property="periodo15" column="valor_h15"/>
>
> <result property="periodo16" column="valor_h16"/>
>
> <result property="periodo17" column="valor_h17"/>
>
> <result property="periodo18" column="valor_h18"/>
>
> <result property="periodo19" column="valor_h19"/>
>
> <result property="periodo20" column="valor_h20"/>
>
> <result property="periodo21" column="valor_h21"/>
>
> <result property="periodo22" column="valor_h22"/>
>
> <result property="periodo23" column="valor_h23"/>
>
> <result property="periodo24" column="valor_h24"/>
>
> <result property="periodo25" column="valor_h25"/>
>
> </resultMap>
>
> <sql id="fragmento_fechas">
>
> (
>
> vwpm.f_desde_pf <![CDATA[<=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_desde_pf <![CDATA[<=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> AND (
>
> vwpm.f_hasta_pf <![CDATA[>=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_hasta_pf <![CDATA[>=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> AND (
>
> vwpm.f_desde_pm <![CDATA[<=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_desde_pm <![CDATA[<=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> AND (
>
> vwpm.f_hasta_pm <![CDATA[>=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_hasta_pm <![CDATA[>=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> AND (
>
> vwpm.f_desde_cpf <![CDATA[<=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_desde_cpf <![CDATA[<=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> AND(
>
> vwpm.f_hasta_cpf <![CDATA[>=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_hasta_cpf <![CDATA[>=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> AND (
>
> vwpm.f_desde_apmpf <![CDATA[<=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_desde_apmpf <![CDATA[<=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> AND (
>
> vwpm.f_hasta_apmpf <![CDATA[>=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_hasta_apmpf <![CDATA[>=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> AND (
>
> vwpm.f_desde_cpm <![CDATA[<=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_desde_cpm <![CDATA[<=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> AND (
>
> vwpm.f_hasta_cpm <![CDATA[>=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_hasta_cpm <![CDATA[>=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> AND (
>
> vwpm.f_desde_cpma <![CDATA[<=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_desde_cpma <![CDATA[<=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> AND (
>
> vwpm.f_hasta_cpma <![CDATA[>=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_hasta_cpma <![CDATA[>=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> AND (
>
> vwpm.f_desde_tc <![CDATA[<=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_desde_tc <![CDATA[<=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> AND (
>
> vwpm.f_hasta_tc <![CDATA[>=]]> to_date(#fecha_desde#,'yyyymmdd')
>
> OR vwpm.f_hasta_tc <![CDATA[>=]]> to_date(#fecha_hasta#,'yyyymmdd')
>
> )
>
> </sql>
>
> <select id="obtenerCurvas" resultMap="curvaHorariaResult"
> parameterClass="curvaHoraria">
>
> SELECT distinct(guid_pm), fecha, valor_h01, valor_h02, valor_h03,
> valor_h04, valor_h05, valor_h06, valor_h07,
>
> valor_h08, valor_h09, valor_h10, valor_h11, valor_h12, valor_h13,
> valor_h14, valor_h15, valor_h16, valor_h17,
>
> valor_h18, valor_h19, valor_h20, valor_h21, valor_h22, valor_h23,
> valor_h24, valor_h25
>
> from FLUMEN.vw_puntos_medida_ve vwpm, flumen.variables_periodo vp,
> flumen.periodovar p
>
> where vwpm.id_ccaa = vp.id_sitio
>
> and substr(vwpm.tarifa, 1, 1) = substr(vp.tarifa, 1, 1)
>
> and vp.id_var = p.id_var
>
> and p.fecha <![CDATA[>=]]> #fecha_desde#
>
> and p.fecha <![CDATA[<=]]> #fecha_hasta#
>
> AND
>
> <include refid="fragmento_fechas"/>
>
> order by guid_pm, fecha
>
> </select>
>
> <select id="obtenerPMs" resultClass="java.lang.String"
> parameterClass="curvaHoraria">
>
> select distinct(guid_pm) from FLUMEN.vw_puntos_medida_ve vwpm
>
> WHERE
>
> <include refid="fragmento_fechas"/>
>
> </select>
>
> </sqlMap>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ------------------------------------------------------------------
> This e-mail and the documents attached are confidential and intended
> solely
> for the addressee; it may also be privileged. If you receive this
> e-mail
> in error, please notify the sender immediately and destroy it.
> As its integrity cannot be secured on the Internet, the Atos Origin
> group
> liability cannot be triggered for the message content. Although the
> sender endeavours to maintain a computer virus-free network, the
> sender does
> not warrant that this transmission is virus-free and will not be
> liable for
> any damages resulting from any virus transmitted.
>
> Este mensaje y los ficheros adjuntos pueden contener informacion
> confidencial destinada solamente a la(s) persona(s) mencionadas
> anteriormente. Pueden estar protegidos por secreto profesional Si
> usted
> recibe este correo electronico por error, gracias de informar
> inmediatamente
> al remitente y destruir el mensaje.
> Al no estar asegurada la integridad de este mensaje sobre la red, Atos
> Origin no se hace responsable por su contenido. Su contenido no
> constituye
> ningun compromiso para el grupo Atos Origin, salvo ratificacion
> escrita por
> ambas partes.
> Aunque se esfuerza al maximo por mantener su red libre de virus, el
> emisor
> no puede garantizar nada al respecto y no sera responsable de
> cualesquiera
> danos que puedan resultar de una transmision de virus
> ------------------------------------------------------------------
>




------------------------------------------------------------------
This e-mail and the documents attached are confidential and intended solely
for the addressee; it may also be privileged. If you receive this e-mail
in error, please notify the sender immediately and destroy it.
As its integrity cannot be secured on the Internet, the Atos Origin group
liability cannot be triggered for the message content. Although the
sender endeavours to maintain a computer virus-free network, the sender does
not warrant that this transmission is virus-free and will not be liable for
any damages resulting from any virus transmitted.

Este mensaje y los ficheros adjuntos pueden contener informacion
confidencial destinada solamente a la(s) persona(s) mencionadas
anteriormente. Pueden estar protegidos por secreto profesional Si usted
recibe este correo electronico por error, gracias de informar inmediatamente
al remitente y destruir el mensaje.
Al no estar asegurada la integridad de este mensaje sobre la red, Atos
Origin no se hace responsable por su contenido. Su contenido no constituye
ningun compromiso para el grupo Atos Origin, salvo ratificacion escrita por
ambas partes.
Aunque se esfuerza al maximo por mantener su red libre de virus, el emisor
no puede garantizar nada al respecto y no sera responsable de cualesquiera
danos que puedan resultar de una transmision de virus
------------------------------------------------------------------



------------------------------------------------------------------
This e-mail and the documents attached are confidential and intended solely
for the addressee; it may also be privileged. If you receive this e-mail
in error, please notify the sender immediately and destroy it.
As its integrity cannot be secured on the Internet, the Atos Origin group
liability cannot be triggered for the message content. Although the
sender endeavours to maintain a computer virus-free network, the sender does
not warrant that this transmission is virus-free and will not be liable for
any damages resulting from any virus transmitted.

Este mensaje y los ficheros adjuntos pueden contener informacion
confidencial destinada solamente a la(s) persona(s) mencionadas
anteriormente. Pueden estar protegidos por secreto profesional Si usted
recibe este correo electronico por error, gracias de informar inmediatamente
al remitente y destruir el mensaje.
Al no estar asegurada la integridad de este mensaje sobre la red, Atos
Origin no se hace responsable por su contenido. Su contenido no constituye
ningun compromiso para el grupo Atos Origin, salvo ratificacion escrita por
ambas partes.
Aunque se esfuerza al maximo por mantener su red libre de virus, el emisor
no puede garantizar nada al respecto y no sera responsable de cualesquiera
danos que puedan resultar de una transmision de virus
------------------------------------------------------------------


Mime
View raw message