hibernate性能测试 (补17年1月)-CSDN博客

本文链接：https://blog.csdn.net/hanlin0605/article/details/54834717

涉及大数据量操作，框架选型时我们需要对比hibernate和mybatis的性能，我负责hibernate，写出了hibernate的增删改查代码，修改数量级参数，即可获得操作时间

前辈们对hibernate的性能优化有很多方法，最常用的方法就是分段提交 和绕过hibernate API 直接用JDBC去操作数据库，众所周知，JDBC肯定是最快的！

以下代码体现了分段提交以及用JDBC操作数据库

增：

package com.shuyu.hibernate;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import com.shuyu.bean.BaseDepartment;

public class BaseInsert {

	public static void main(String[] args) {
		/** 加载配置文件*/
		Configuration configuration = new Configuration().configure();
		SessionFactory sessionFactory = configuration.buildSessionFactory(); 
		/** 打开session*/
		Session session = sessionFactory.openSession();
		/** 利用session打开事务*/
		Transaction transaction = session.beginTransaction();
		
		long count = 0;
		long startTime = System.currentTimeMillis();		
		for(int i=0; i<50000; i++){
			BaseDepartment basedepartment = new BaseDepartment("haa-"+i);
			session.save(basedepartment);
			if(i%1000==0){
				session.flush();
				session.clear();
			}
		}
		long endTime = System.currentTimeMillis();
		float excTime = (float)(endTime - startTime)/1000;
		/** 提交事务*/
		transaction.commit();		
		/** 关闭session*/
		session.close();
		System.out.println("执行时间: " + excTime + "s  " +"插入条数: "+count );
		System.out.println("====================================================================");
		System.out.println("program end !");  
	}
}

删：

package com.shuyu.hibernate;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class BaseDelete {

	public static void main(String[] args) {
		/** 加载配置文件*/
		Configuration configuration = new Configuration().configure();
		SessionFactory sessionFactory = configuration.buildSessionFactory(); 
		/** 打开session*/
		Session session = sessionFactory.openSession();
		/** 利用session打开事务*/
		Transaction transaction = session.beginTransaction();
		
		long count = 0 ;
		long startTime = System.currentTimeMillis();
		String hql = "delete BaseDepartment where department_guid "
				+ " like '%ha%'";
		Query query = session.createQuery(hql);
		long size = query.executeUpdate();
		
		long endTime = System.currentTimeMillis();
		float excTime = (float)(endTime - startTime)/1000;
		/** 提交事务*/
		transaction.commit();		
		/** 关闭session*/
		session.close();

		System.out.println("执行时间: " + excTime + "s  " +"删除条数: "+size );
		System.out.println("====================================================================");
		System.out.println("program end !");  
	}
}

改：

package com.shuyu.hibernate;

import org.hibernate.CacheMode;
import org.hibernate.ScrollMode;
import org.hibernate.ScrollableResults;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import com.shuyu.bean.BaseDepartment;

public class BaseUpdate {
	public static void main(String[] args){
		/** 加载配置文件*/
		Configuration configuration = new Configuration().configure();
		SessionFactory sessionFactory = configuration.buildSessionFactory(); 
		/** 打开session*/
		Session session = sessionFactory.openSession();
		/** 利用session打开事务*/
		Transaction transaction = session.beginTransaction();
		long count = 0;
		/** 方法1:使用 hibernate 批量更新表数据 */
		
		/** 方法一
		Iterator BaseDepartments = session.createQuery("from BaseDepartment b "
				+ "where b.departmentIndex > -1 and rownum <=30000").iterate();
		long startTime = System.currentTimeMillis();
		while(BaseDepartments.hasNext()){
			BaseDepartment basedepartment=(BaseDepartment)BaseDepartments.next();
			basedepartment.setDepartmentIndex(basedepartment.getDepartmentIndex() + 80);
			count++;
			if(count%1000==0){
				session.flush();
				session.evict(basedepartment);
				session.clear();
			}
		}			
		*/
		/** 方法二 */
		
		ScrollableResults BaseDepartments = session.createQuery("from BaseDepartment b "
				+ "where b.departmentIndex > -1 and rownum <=30000")
				.setCacheMode(CacheMode.IGNORE).scroll(ScrollMode.FORWARD_ONLY);
		long startTime = System.currentTimeMillis();
		while(BaseDepartments.next()){
			BaseDepartment d = (BaseDepartment)BaseDepartments.get(0);
			d.setDepartmentFullname("hhhhh"+count);
			if(++count % 5000 ==0){
				session.flush();
				session.clear();
			}
		}
		
		
		/**方法三  */
		/**
		long startTime = System.currentTimeMillis();
		String hql = "update BaseDepartment set department2wname = "
				+ " 'haaaaaaa' where rownum <=30000";
		Query query = session.createQuery(hql);
		long size = query.executeUpdate();
		*/
		
		/** 方法2:绕过 Hibernate API,直接通过JDBC API来做批量操作 */
		
		
		
		long endTime = System.currentTimeMillis();
		float excTime = (float)(endTime - startTime)/1000;
		/** 提交事务*/
		transaction.commit();		
		/** 关闭session*/
		session.close();
		System.out.println("执行时间: " + excTime + "s  " +"更新条数: "+count );
		//System.out.println("执行时间: " + excTime + "s  " +"更新条数: "+size );
		System.out.println("====================================================================");
		System.out.println("program end !");  
	}
}

查：

package com.shuyu.hibernate;

import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class BaseQuery {

	public static void main(String[] args) {

		/** 加载配置文件*/
		Configuration configuration = new Configuration().configure();
		SessionFactory sessionFactory = configuration.buildSessionFactory(); 
		/** 打开session*/
		Session session = sessionFactory.openSession();
		/** 利用session打开事务*/
		Transaction transaction = session.beginTransaction();
		/** list集合的大小 */
		long numSingle = 0 ;
		long numMany = 0 ;
		long startTime = System.currentTimeMillis();
		List rst = session.createSQLQuery("select * from BASE_DEPARTMENT WHERE ROWNUM <= 10").list();
		String sql = "select * from (select A.DEPARTMENT_GUID,B.EMPLOYEE_GUID,C.EMPLOYEE_ROLE_ID,D.IS_ALIASUSER,E.ID "+
					"from base_department A,base_employee B,base_employee_role C,base_emp_dep D,base_role E " +
					"where A.department_guid = B.employee_guid and B.employee_guid = C.EMPLOYEE_ROLE_ID and "+
					"C.employee_role_id = D.EMPLOYEE_GUID and D.employee_guid = E.ID ) t where ROWNUM <= 10";
		
		List rstMany = session.createSQLQuery(sql).list();
		/**
		 * 不建议使用以下设定范围的方式,因为查询效率低
		 * List rst = session.createQuery("from BaseDepartment").setFirstResult(0).setMaxResults(10000).list();
		 */
		long endTime = System.currentTimeMillis();
		float excTime = (float)(endTime - startTime)/1000;
		/** 提交事务*/
		transaction.commit();		
		/** 关闭session*/
		session.close();
		numSingle = rst.size();
		numMany = rstMany.size();
		System.out.println("执行时间: " + excTime + "s   " + "单表记录条数 :" + numSingle);
		System.out.println("执行时间: " + excTime + "s   " + "多表记录条数 :" + numMany);
		System.out.println("====================================================================");
		System.out.println("program end !");  
	}
	
	/**
	 * 查询数据性能测试
	 */
	public void queryData(){		
		
		/**
		 * 左连接  以A作主表
		 * select count(*) from
			(
			select A.DEPARTMENT_GUID,B.Employee_Guid,C.EMPLOYEE_ROLE_ID,D.IS_ALIASUSER,E.ID
			from base_department A 
			left join base_employee B on A.department_guid = B.employee_guid 
			left join base_employee_role C on B.employee_guid = C.EMPLOYEE_ROLE_ID 
			left join base_emp_dep D on C.employee_role_id = D.EMPLOYEE_GUID 
			left join base_role E on D.employee_guid = E.ID
			) t
		 */
		
		/**
		 * 左连接 以B作主表 
		 * select count(*) from
			(
			select A.DEPARTMENT_GUID,B.Employee_Guid,C.EMPLOYEE_ROLE_ID,D.IS_ALIASUSER,E.ID 
			from base_employee B 
			left join base_department A on A.department_guid = B.employee_guid 
			left join base_employee_role C on B.employee_guid = C.EMPLOYEE_ROLE_ID 
			left join base_emp_dep D on C.employee_role_id = D.EMPLOYEE_GUID 
			left join base_role E on D.employee_guid = E.ID
			) t
		 */
	}
}

JDBC:

package com.shuyu.hibernate;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class BaseJDBC {

	public static void main(String[] args) {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String username = "system";
			String password = "123456";
			String url = "jdbc:oracle:thin:@192.168.1.139:1521:orcl";
			Connection con = DriverManager.getConnection(url,username,password);		
			Statement stmt = con.createStatement();
			String sql = "update BASE_DEPARTMENT set DEPARTMENT_2WNAME= "
					+ "'hhhhh' where rownum <= 500000";
			long startTime = System.currentTimeMillis();
			int executeResult = stmt.executeUpdate(sql);
			long endTime = System.currentTimeMillis();
			float excTime = (float)(endTime - startTime)/1000;
			System.out.println("数据更新成功！");
			System.out.println("执行时间: " + excTime + "s   " + "记录条数 :" + executeResult);
			System.out.println("====================================================================");
			System.out.println("program end !");  
		} catch (ClassNotFoundException | SQLException e) {
			e.printStackTrace();
		}
	}
}

源代码下载点击这里

帮助网页1，深度好文！！！

帮助网页2，深度好文！！！