Mysql 5.0 hibernate data query 5000000

sponsored links
(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
  • del.icio.us
  • StumbleUpon
  • Digg
  • TwitThis
  • Mixx
  • Technorati
  • Facebook
  • NewsVine
  • Reddit
  • Google
  • LinkedIn
  • YahooMyWeb
Tags:

Related Posts of Mysql 5.0 hibernate data query 5000000

  • 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.XmlBeanDef

  • Data using the Hibernate database query has cleared the corresponding table of contents

    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 has put

  • mysql query day, queries a week, one month's data query

    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 (

  • Hibernate first 04 classes: hibernate data management

    In fact already realize how to insert data, update data how. Now know how to query the data. Hibernate in the call load at the data. There are two ways to get and are separately load. update the data can also be manually set up an object, and then update

  • Java data type, Hibernate data types, standard sql data type correspondence table between

    Hibernate API Introduction Its interface is divided into the following categories: l provide access to the database operation interface; l used to configure the Hibernate interfaces; l callback interfaces l extend Hibernate functionality of the interfaces

  • hibernate hql query language

    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 type, a

  • Mysql reference to official data, the absolute complete

    First, the connection MYSQL. Format: mysql-h host address-u username-p password 1, Example 1: Connect to the machine on MYSQL. First, open a DOS window, then enter the directory mysqlbin, and then type the command mysql-uroot-p, enter the password af

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

    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 optimization of massive data

    MySQL optimization of massive data Often see people on the MySQL process massive amounts of data (millions, tens of millions of data, do not pull up to the mass above) the ability to be skeptical, in my experience, MySQL data in one hundred million d

  • Hibernate data retention

    Hibernate data retention - Session. Save Ways Session.save user entity objects to the database persistence operations. In other words, Session.save method call with the entity object by matching Insert SQL, data insert database table. Ways Session.sa ...

blog comments powered by Disqus
Recent
Recent Entries
Tag Cloud
Random Entries