Mysql 5.0 hibernate data query 5000000

(support.XmlWebApplicationContext 412) Refreshing org.springframework.web.context.support.XmlWebApplicationContext @ 1581593: display name [Root WebApplicationContext]; startup date [Tue Mar 27 01:33:55 CST 2007]; root of context hierarchy
(xml.XmlBeanDefinitionReader 323) Loading XML bean definitions from file [G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ test \ util \ applicationContext-dao.xml]
(xml.XmlBeanDefinitionReader 323) Loading XML bean definitions from file [G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ test \ util \ applicationContext-hibernate.xml]
(xml.XmlBeanDefinitionReader 323) Loading XML bean definitions from file [G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ test \ util \ applicationContext-index.xml]
(xml.XmlBeanDefinitionReader 323) Loading XML bean definitions from file [G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ test \ util \ applicationContext-indexService.xml]
(xml.XmlBeanDefinitionReader 323) Loading XML bean definitions from file [G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ test \ util \ applicationContext-resources.xml]
(xml.XmlBeanDefinitionReader 323) Loading XML bean definitions from file [G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ test \ util \ applicationContext-service.xml]
(xml.XmlBeanDefinitionReader 323) Loading XML bean definitions from file [G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ test \ util \ applicationContext-userDao.xml]
(xml.XmlBeanDefinitionReader 323) Loading XML bean definitions from file [G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ test \ util \ applicationContext-userService.xml]
(xml.XmlBeanDefinitionReader 323) Loading XML bean definitions from URL [file: / G: / haiwooo / workspace / sky / WebRoot / WEB-INF / classes / test / util / action-servlet.xml]
(support.XmlWebApplicationContext 427) Bean factory for application context [org.springframework.web.context.support.XmlWebApplicationContext @ 1581593]: org.springframework.beans.factory.support.DefaultListableBeanFactory @ 458f41
(config.PropertyPlaceholderConfigurer 178) Loading properties file from class path resource [mail.properties]
(support.DefaultListableBeanFactory 414) Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory @ 458f41: defining beans [dao, orderTaskDao, orderDao, userCountDao, sessionFactory, transactionManager, indexDao, bookDao, companyDao, indexManager, companyManager, propertyConfigurer, dataSource, baseManager, userDao, org.springframework.aop.config.internalAutoProxyCreator, userManagerTx, userManagerSecurity, managerTx, orderManagerTx, txAdvice, userManagerTxAdvice, userSecurityAdvice, manager, userManager, userCache, orderManager, userCountManager, orderOpration, orderManagerTxAdvice, loginAction, registAction, fileDownLoadAction, commandIndexAction, adminIndexAction, indexAction, companyAction, mergeAction, orderAction, eventAction, eventCrimeAction]; root of factory hierarchy
(cfg.Environment 514) Hibernate 3.2.6
(cfg.Environment 547) hibernate.properties not found
(cfg.Environment 681) Bytecode provider name: cglib
(cfg.Environment 598) using JDK 1.4 java.sql.Timestamp handling
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ common \ CarForumDetail.hbm. xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.common.CarForumDetail -> test
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ common \ ForumRole.hbm. xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.common.ForumRole -> Forum_Role
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ Company.hbm.xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.Company -> company
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ Count.hbm.xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.Count -> count
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ CrimeEvent.hbm.xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.CrimeEvent -> crime_event
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ GoodsStorage.hbm.xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.GoodsStorage -> goods_storage
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ hainan \ HaiKouCarForum.hbm. xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.hainan.HaiKouCarForum -> Hai_Kou_Car_Forum
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ hainan \ HaiKouCarForumDetail.hbm. xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.hainan.HaiKouCarForumDetail -> Hai_Kou_Car_Forum_Detail
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ hainan \ HaiKouCarForumReply.hbm. xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.hainan.HaiKouCarForumReply -> Hai_Kou_Car_Forum_Reply
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ hainan \ TestTable.hbm. xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.hainan.TestTable -> test_table
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ index \ Book.hbm. xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.index.Book -> book
(cfg.HbmBinder 873) Mapping joined-subclass: com.sky.model.pojo.index.NewsBook -> news_book
(cfg.HbmBinder 873) Mapping joined-subclass: com.sky.model.pojo.index.CommandBook -> command_book
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ index \ BookAddress.hbm. xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.index.BookAddress -> book_address
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ index \ BookCatalog.hbm. xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.index.BookCatalog -> book_catalog
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ Industry.hbm.xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.Industry -> industry
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ MergerCompany.hbm.xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.MergerCompany -> merger_company
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ Order.hbm.xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.Order -> orders
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ Role.hbm.xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.Role -> role
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ SystemInfo.hbm.xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.SystemInfo -> system_info
(cfg.Configuration 305) Reading mappings from file: G: \ haiwooo \ workspace \ sky \ WebRoot \ WEB-INF \ classes \ com \ sky \ xml \ hibernate \ com \ sky \ model \ pojo \ User.hbm.xml
(cfg.HbmBinder 300) Mapping class: com.sky.model.pojo.User -> user
(cfg.HbmBinder 1419) Mapping collection: com.sky.model.pojo.User.roles -> user_role
(cfg.HbmBinder 2382) Mapping collection: com.sky.model.pojo.hainan.HaiKouCarForum.list -> Hai_Kou_Car_Forum_Reply
(cfg.HbmBinder 2382) Mapping collection: com.sky.model.pojo.index.Book.catalogList -> book_catalog
(cfg.HbmBinder 2382) Mapping collection: com.sky.model.pojo.index.Book.bookAddressList -> book_address
(cfg.HbmBinder 2382) Mapping collection: com.sky.model.pojo.MergerCompany.crimeEventList -> crime_event
(hibernate3.LocalSessionFactoryBean 730) Building new Hibernate SessionFactory
(connection.ConnectionProviderFactory 72) Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool @ 63b2e6)
LogAbandoned: false
RemoveAbandoned: true
RemoveAbandonedTimeout: 60
(cfg.SettingsFactory 89) RDBMS: MySQL, version: 5.0.27-community-nt
(cfg.SettingsFactory 90) JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.3 ($ Date: 2006-07-26 17:26:47 +0200 (Wed, 26 Jul 2006) $ , $ Revision: 5553 $)
(dialect.Dialect 152) Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
(transaction.TransactionFactoryFactory 34) Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory
(transaction.TransactionManagerLookupFactory 33) No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
(cfg.SettingsFactory 143) Automatic flush during beforeCompletion (): disabled
(cfg.SettingsFactory 147) Automatic session close at end of transaction: disabled
(cfg.SettingsFactory 154) JDBC batch size: 2000
(cfg.SettingsFactory 157) JDBC batch updates for versioned data: disabled
(cfg.SettingsFactory 162) Scrollable result sets: enabled
(cfg.SettingsFactory 170) JDBC3 getGeneratedKeys (): enabled
(cfg.SettingsFactory 178) Connection release mode: auto
(cfg.SettingsFactory 202) Maximum outer join fetch depth: 2
(cfg.SettingsFactory 205) Default batch fetch size: 1
(cfg.SettingsFactory 209) Generate SQL with comments: disabled
(cfg.SettingsFactory 213) Order SQL updates by primary key: disabled
(cfg.SettingsFactory 217) Order SQL inserts for batching: disabled
(cfg.SettingsFactory 386) Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
(ast.ASTQueryTranslatorFactory 24) Using ASTQueryTranslatorFactory
(cfg.SettingsFactory 225) Query language substitutions: ()
(cfg.SettingsFactory 230) JPA-QL strict compliance: disabled
(cfg.SettingsFactory 235) Second-level cache: enabled
(cfg.SettingsFactory 239) Query cache: disabled
(cfg.SettingsFactory 373) Cache provider: org.hibernate.cache.NoCacheProvider
(cfg.SettingsFactory 254) Optimize cache for minimal puts: disabled
(cfg.SettingsFactory 263) Structured second-level cache entries: disabled
(cfg.SettingsFactory 283) Echoing all SQL to stdout
(cfg.SettingsFactory 290) Statistics: disabled
(cfg.SettingsFactory 294) Deleted entity synthetic identifier rollback: disabled
(cfg.SettingsFactory 309) Default entity-mode: pojo
(cfg.SettingsFactory 313) Named query checking: enabled
(impl.SessionFactoryImpl 161) building session factory
(impl.SessionFactoryObjectFactory 82) Not binding factory to JNDI, no JNDI name configured
(hibernate3.HibernateTransactionManager 390) Using DataSource [org.apache.commons.dbcp.BasicDataSource @ 1cec874] of Hibernate SessionFactory for HibernateTransactionManager
(ehcache.EhCacheManagerFactoryBean 100) Initializing EHCache CacheManager
(config.ConfigurationFactory 127) No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar: file: / G: / haiwooo/workspace/sky/lib/ehcache-1.3.0.jar! / ehcache - failsafe.xml
===
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?
0 select to 1000 = 4829
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1 select to 1000 = 3890
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
4 select to 1000 = 3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
9 select to 1000 = 3985
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
16 select to 1000 = 3953
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
25 select to 1000 = 3953
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
36 select to 1000 = 3984
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
49 select to 1000 = 3938
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
64 select to 1000 = 3922
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
81 select to 1000 = 3968
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
100 select to 1000 = 3922
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
121 select to 1000 = 3906
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
144 select to 1000 = 3922
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
169 select to 1000 = 3922
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
196 select to 1000 = 3938
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
225 select to 1000 = 3937
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
256 select to 1000 = 4016
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
289 select to 1000 = 4015
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
324 select to 1000 = 3907
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
361 select to 1000 = 3937
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
400 select to 1000 = 3891
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
441 select to 1000 = 3906
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
484 select to 1000 = 3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
529 select to 1000 = 3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
576 select to 1000 = 3906
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
625 select to 1000 = 3907
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
676 select to 1000 = 3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
729 select to 1000 = 3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
784 select to 1000 = 3890
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
841 select to 1000 = 3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
900 select to 1000 = 3922
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
961 select to 1000 = 3984
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1024 select to 1000 = 3891
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1089 select to 1000 = 3953
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1156 select to 1000 = 3953
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1225 select to 1000 = 3922
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1296 select to 1000 = 3906
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1369 select to 1000 = 3844
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1444 select to 1000 = 3953
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1521 select to 1000 = 3844
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1600 select to 1000 = 3844
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1681 select to 1000 = 3969
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1764 select to 1000 = 4000
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1849 select to 1000 = 3968
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
1936 select to 1000 = 3860
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
2025 select to 1000 = 3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
2116 select to 1000 = 3890
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
2209 select to 1000 = 3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
2304 select to 1000 = 3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like? Order by testtable0_.date_Times limit?,?
2401 select to 1000 = 3875
Hibernate: insert into test_table (date_Times, descriptions, names) values (?,?,?)
insert one = 203

=================================================

Test results

However, there is no correlation table

First general inquiries over 1300 ms

Other on average 450 ms

Like the use of query

First 4829 ms

Other on average 4000 ms

This is not the result of any of the optimization process

分类:Java 时间:2009-05-15 人气:436
本文关键词:
分享到:
blog comments powered by Disqus

相关文章

  • Sharing in the next MySQL 5.0.22-Noinstal installation of Windows on 2010-05-31

    Installation: 1. Download mysql-noinstall-5.0.22-win32.zip. Two. Unzip to C: \ mysql, copy my-medium.ini to C: \ WINDOWS, and rename the my.ini. 3. Edit my.ini, in the [mysqld] section add the following two sentences: Increase: default-storage-engine

  • Data using the Hibernate database query has cleared the corresponding table of contents 2010-04-19

    These days, when in the use of Hibernate framework, there was a problem when I insert the data, to the right to run a query data, even the most simple one table out of all the data query can not be successful, the most depressed, after inquiry, it ha

  • mysql query day, queries a week, one month's data query 2011-06-21

    mysql query day, queries a week, one month's data query queries a day: select * from table where to_days (column_time) = to_days (now ()); select * from table where date (column_time) = curdate (); Query week: select * from table where DATE_SUB (CURD

  • Hibernate in query.setFirstResult (), query.setMaxResults (); 2010-12-27

    setFirstResult is the initial data, setMaxResults is the query and display data. If the pager on the inside setFirstResult the value should be (the current page -1) X number of articles per page, setMaxResults is the number of articles per page. A, q

  • Application of spring struts2.0 hibernate HQL 2009-02-27

    Therefore, in the development of statistical inquiry system, as far as possible through the use of select statement to write the required query property way back relational data, and avoid using the first query return persistent object (in this way a

  • CentOS / linux under MySql 5.0.x installation. Optimization and security settings 2010-07-18

    Original Address: http://blog.chinaunix.net/u2/82530/showart_1956918.html Download page: http://dev.mysql .com/downloads/mysql/5.0.html # downloads To the bottom of the page to find the Source downloads, this is the source version, download the first

  • hibernate hql query language 2010-10-27

    hibernate hql query language Hql in the keywords in the not case sensitive, but the property and class names are case-sensitive 1, a simple attribute query [important] * Single attribute query and returns the result set list of attributes, element ty

  • (R) linux mysql open under the slow query, analysis, query one, why should open this query? 2010-08-18

    Open the mysql slow query under linux, analysis, query one, why should open this query? Database is very easy to create a bottleneck where now Nosql discussion so hot, it is estimated to engage in the database have been depressed. mysql speed is the

  • MySQL 5.0 New Features tutorial storage process: Lecture 2011-04-12

    Why MySQL Statements are Legal in a Procedure Body What MySQL storage processes in the body of the statement is justified? What kind of SQL statement stored in the Mysql process is legitimate it? You can create an include INSERT, UPDATE, DELETE, SELE

iOS 开发

Android 开发

Python 开发

JAVA 开发

开发语言

PHP 开发

Ruby 开发

搜索

前端开发

数据库

开发工具

开放平台

Javascript 开发

.NET 开发

云计算

服务器

Copyright (C) codeweblog.com, All Rights Reserved.

CodeWeblog.com 版权所有 黔ICP备15002463号-1

processed in 0.292 (s). 12 q(s)