Hibernate连接Sybase的性能
今天简单地比较了一下Hibernate和JDBC的性能。不知道是否和采用Sybase有关,感觉Hibernate的速度有些超出意外,只一句简单的查询语句,也需要2秒多钟。数据表:
http://www.agoit.com/bbs/../../../upload/picture/pic/6304/c519b484-c63f-4fee-8d5f-03f45fe3ea39.jpg
Hibernate我是用Hibernate Synchronizer生成的:
<div class="code_title"><div class="dp-highlighter"><div class="bar" />
[*] try
[*]{
[*] long starttime = System.currentTimeMillis();
[*] _RootDAO.initialize();
[*] TSTaskSpecWorker aTaskSpecWorker = new TSTaskSpecWorker();
[*] TSTaskSpecWorkerDAO dao = new TSTaskSpecWorkerDAO();
[*]
[*]
[*]
[*] TSTaskSpecWorkerPK pk = new TSTaskSpecWorkerPK();
[*] pk.setaWorkerID("1");
[*] pk.setiSTaskID(2);
[*]
[*] aTaskSpecWorker = dao.load(pk);
[*]
[*] System.out.println(aTaskSpecWorker.getaPhoneCode() + " : " + aTaskSpecWorker.getaBankID());
[*]
[*] long endtime = System.currentTimeMillis();
[*]
[*] System.out.println("cost time:" + (endtime - starttime));
[*]
[*]}
[*]catch(Exception ex)
[*]{
[*] ex.printStackTrace();
[*]}
页:
[1]