hibernate性能提升

作者:xiaoliu52013 日期:2007-10-08 10:21:26

字体大小: 小中大

1、针对oracle数据库而言，Fetch Size 是设定JDBC的Statement读取数据的时候每次从数据库中取出的记录条数，一般设置为30、50、100。Oracle数据库的JDBC驱动默认的Fetch Size=15，设置Fetch Size设置为：30、50，性能会有明显提升，如果继续增大，超出100，性能提升不明显，反而会消耗内存。

　　即在hibernate配制文件中进行配制：

1 ＜property name="hibernateProperties"＞
2 ＜props＞
3 ＜prop key="hibernate.dialect"＞org.hibernate.dialect.Oracle9Dialect＜/prop＞
4 ＜prop key="hibernate.show_sql"＞false＜/prop＞
5 ＜!-- Create/update the database tables automatically when the JVM starts up
6 ＜prop key="hibernate.hbm2ddl.auto"＞update＜/prop＞ --＞
7 ＜!-- Turn batching off for better error messages under PostgreSQL 
8 ＜prop key="hibernate.jdbc.batch_size"＞100＜/prop＞ --＞
9 ＜prop key="hibernate.jdbc.batch_size"＞50＜/prop＞
10 ＜/props＞
11 ＜/property＞

Fetch Size设的越大，读数据库的次数越少，速度越快；Fetch Size越小，读数据库的次数越多，速度越慢。

　　 2、如果是超大的系统，建议生成htm文件。加快页面提升速度。

　　 3、不要把所有的责任推在hibernate上，对代码进行重构，减少对数据库的操作，尽量避免在数据库查询时使用in操作，以及避免递归查询操作，代码质量、系统设计的合理性决定系统性能的高低。

　　 4、对大数据量查询时，慎用list()或者iterator()返回查询结果，

　　（1）. 使用List()返回结果时，Hibernate会所有查询结果初始化为持久化对象，结果集较大时，会占用很多的处理时间。

　　（2）. 而使用iterator()返回结果时，在每次调用iterator.next()返回对象并使用对象时，Hibernate才调用查询将对应的对象初始化，对于大数据量时，每调用一次查询都会花费较多的时间。当结果集较大，但是含有较大量相同的数据，或者结果集不是全部都会使用时，使用iterator()才有优势。

　　 5、在一对多、多对一的关系中，使用延迟加载机制，会使不少的对象在使用时方会初始化，这样可使得节省内存空间以及减少数据库的负荷，而且若PO中的集合没有被使用时，就可减少互数据库的交互从而减少处理时间。

　　 6、对含有关联的PO（持久化对象）时，若default-cascade="all"或者 “save-update”，新增PO时，请注意对PO中的集合的赋值操作，因为有可能使得多执行一次update操作。

　　 7、对于大数据量新增、修改、删除操作或者是对大数据量的查询，与数据库的交互次数是决定处理时间的最重要因素，减少交互的次数是提升效率的最好途径，所以在开发过程中，请将show_sql设置为true，深入了解Hibernate的处理过程，尝试不同的方式，可以使得效率提升。尽可能对每个页面的显示，对数据库的操作减少到100----150条以内。越少越好。

平均得分

(0 次评分)

文章来自: 360doc

标签:

评论: 12 | 查看次数: 1214

共有 12 条评论

游客 [2008-11-06 10:44:49]

6shorgy
shuasiny
wow gold
wow power leveling
brogame
brogame
空调
空调
隔膜泵
隔膜泵
磁力泵
磁力泵
磁力泵
磁力泵
真空泵
真空泵
美的空调
美的空调
美的空调
美的空调
海尔空调
海尔空调
上海韩语培训
上海韩语培训
上海韩语培训
菲律宾留学
菲律宾留学
菲律宾留学
大金空调
大金空调
家用中央空调
家用中央空调
上海新加坡留学中介
Cosmetic surgery
上海SAT培训
Cosmetic surgery
磁力泵
美的空调
海尔空调
上海韩语培训
菲律宾留学
菲律宾留学
上海新加坡留学中介
上海新加坡留学

游客 [2008-10-30 14:52:09]

buy wow gold Remember the WoW account hacking. buying gold world of warcraft If you're a WoW player. cheap wow gold you couldn't have missed . cheap wow gold any of the articles posting this issue. cheap wow gold Well, as it turns out, an article posted by . cheapest wow gold grimwell says that someone might have found the problem behind all the . eve isk account hacking, stealing and selling even 5 year's worth items. free online games A piece of the BBC news article says:"Analysis [. free online war games mp3 mp3 player ] showed that. mp3 players it lay dormant on a victims . mp4 machine until . online games they ran World of Warcraft (WoW) at which point it captured login data and sent it to. play war games the hacking group. sell wow gold The group's enthusiastic use of the cursor flaw suggests it is trying to . world of warcraft gold do the same again. wow The online fantasy game . wow gold now has more than eight million active players around the world. wow gold Research by security firm Symantec . wow gold suggests that the raw value of a WoW account is now higher. wow gold than a credit card and its associated verification data. wow gold "Normally, as a WoW player, you'd know about the risks involved when creating an online account, yet some were . wow gold lazy enough not to check on their accounts every once in a while, thus resulting in their items . wow gold kaufen and WoW currency being stolen. wow gold kaufen Everyone knows that . stuff like that happen, some. even managed to hack the Superbowl website and use it . to host code for spyware, so monitor the hell out of your computer!In an article I wrote yesterday. about hackers seeing console users as the new target, there is a comment coming from Stefana Muller.

游客 [2008-10-28 16:57:21]

Buy Lotro Gold | Lord Of The Rings Online Gold
Lotro Accounts
| Buy Lotro Accounts
Lord Of The Rings Online Power Leveling | Lord Of The Rings Online PowerLeveling
Lotro Cd Key | Lord Time Card
Lotro Gold | Lotro Gold Instant Delivery
lord of the rings online accounts | lord of the rings online accounts for sale
Lotro Power Leveling | Lotro Powerleveling
Lord Of The Rings Online Cd Key | Lord Of The Rings Online Time Card
Lord of the Rings Online Gold
Buy Lotro Gold
Sell LoTRO Gold
LoTRO CD Key
LoTRO Europe Gold
Cheap LoTRO Accounts
Lord of the Rings Online Power Leveling
Lord of the Rings online CD Key
Cheap Lotro Gold
Air Jordan Shoes
Warhammer Gold
Warhammer Online Gold
Warhammer Accounts
Warhammer Power Leveling
Warhammer Online Key
Warhammer Gold
Warhammer Online Gold
Warhammer Time Card
Warhammer CD Key
WAR gold
warhammer online gold
Buy WAR gold
Buy warhammer gold
Buy warhammer online gold
warhammer gold
WAR Accounts
warhammer Accounts
warhammer online Accounts
Buy WAR Accounts
warhammer Accounts for sale
Warhammer Power Leveling
Warhammer Online Power Leveling
War Power Leveling
Buy Warhammer Power Leveling
Warhammer PowerLeveling
Cheap Warhammer Power Leveling
Cheap Warhammer Online Power Leveling
Buy War Power Leveling
Warhammer EU Power Leveling
Cheap Warhammer Gold
Cheap Warhammer online gold
Buy Cheap Warhammer Gold
Buy WAR Gold
Warhammer EU Gold
Warhammer EU Power Leveling
Warhammer EU CD Key
Warhammer EU Accounts
Warhammer CD Key
Warhammer online CD Key
Warhammer Timecard
Buy Warhammer Time Card
Warhammer 60 days Time Card
Cheap WAR Accounts
Cheap warhammer Accounts
Cheap warhammer online Accounts
Buy Cheap WAR Accounts
buy Warhammer CD Key
buy Warhammer online CD Key
cheap Warhammer CD key
warhammer time card
Warhammer prepaid time card

游客 [2008-10-16 11:17:37]

手机窃听器
窃听器
手机监听器
监听器
手机窃听器
窃听器
手机监听器
监听器
手机窃听器
窃听器
手机监听器
监听器
手机窃听器│窃听器
手机窃听器│窃听器
手机窃听器│窃听器
手机窃听器│窃听器
手机窃听器│窃听器
手机窃听器│窃听器
手机窃听器│窃听器
手机窃听器│窃听器
手机窃听器│窃听器
手机窃听器│窃听器
手机窃听器│窃听器
手机窃听器│窃听器

游客 [2008-10-10 15:16:05]

游客 [2008-08-06 16:52:11]

Warhammer gold
Cheap Warhammer gold
Warhammer Online gold
WAR Gold
Buy Warhammer Gold
Warhammer Online Gold
Warhammer Gold for sale
Warhammer Accounts
Buy Warhammer Accounts
Cheap Warhammer Accounts
Warhammer Power leveling
WAR Power leveling
Warhammer Online Power Leveling
Warhammer CD Key
WAR CD Key
Warhammer Online CD Key
Warhammer Game Time Card

游客 [2008-07-18 15:51:25]

Best place to start is in Bloodhoof Village in Mulgore.wow geld Go speak to Harn Longcast and buy Brilliant Smallfish him.mp3 players Now start fishing in Stonebull Lake.mp3 player Equip your rod and then apply the shiny bauble lure to it.wow level service as this will make catching fish easier.You'll want to catch about 60 Brilliant minutes.mp3 players You'll find that by the time you have Smallfish.mp3 player you'll also have about 30 Longjaw Mud Snappers.wow Once you have 60.mp3 players cook them.mp3 player You can own fire or jog back.wow gold to Harn Longcast and use the fire in front of him.wow schnell gold Cook the Brilliant Smallfish.gold für wow then at level 50 start cooking Longja.wow gold paypal Mud Snappers (after learning the recipe you bought earlier).You'll need to go and catch Longjaw.gold in wow Mud Snappers now and the place for these is.wow gold 1000 the pond in Orgrimmar by Lumark the Fishing trainer.wow power leveling (I know you've been catching quite a few where you are.wowgold but the "drop rate" is a lot better in Orgrimmar).Between levels 50 and 75 go and cooking.wowgold You'll now need to catch about 30 Longjaw 100.world of warcraft power leveling Now go to Mill in Hillsbrad and buy Bristle Whisker.wow golds Catfish recipe off of Derak Nightfall.cheapest wow gold Go to Mill and fish for Bristle Whisker Catfish.wow lvl Depending on your cooking level.world of warcraft power leveling Between levels 125 expert cooking from trainer.buy mp3 players You'll need and buy a book for your Fishing level.

Speak tobuy the book Expert Fishing: The Bass and You.Once your up to 175 cooking, go to Shadowprey Village in Desolace.

游客 [2008-07-18 15:44:10]

Hey whats up guys New to the board.wow gold I'm in a bit of a dilema.wow gold welcome to my blog. mining and skinning as professions.world of warcraft gold I've made tons of with this guy.wow geld Enough money that I was able to buy.wow powerlevel my mount at level 40 with no problem at all.buy wow gold So now Im about to create an ALT toon and was wondering.wow which professions would compliment my.wow gold level 44 warrior and make me money at the same time.cheap wow gold One of my friends sayd I should go with disenchanting.serveur wow and blacksmithing but I don't know if there.wow europe is any money to be made in those.cheapest wow gold What do you guys think.wow power leveling Blacksmithing doesn't really pay off that well.wow powerleveling And I think that your warrior is geared quite well.gold wow so that the blacksmithing skill would have.mp3 players to be levelled quitea lot before you.mp3 player can make some nice and useful things.One crafting skill that compliments a warrior is alchemy.wow gold You can brew potions that he can consume.mp3 player and which are quite helpful in battle.zubehoer mp3 player There are potions to replenish lost health or rage.wow gold kaufen and there are battle and guardian elixirs to give you a boost.mp3 You could try enchanting to boost your warrior's gear.mp4 but then your other skill would have to be. mp4one where you can create green items (such as tailoring or leatherworking) to be disenchanted.

You can also send any useless greens you find with your warriorwow gold to your alt.but it's easier if you can also make your own.

游客 [2008-07-18 15:42:49]

war hero online

free online games

play war games

free online war games

online games

游客 [2008-07-08 10:46:48]

At this stage, you've got some unzipped folders sitting in front of you.level wow it's time to find them a home.buy mp3 player You'll need to locate your World of Warcraft folder.best mp3 player I'll detail how this is done for a default installation.wow lvl using the default file structure.1BG MP3 PLAYER Hopefully if you know enough to change the defaults.2BG MP3 PLAYER you won't need this guide.wow powerlevel For Mac users.mp3 player kaufen you will need to open a new Finder window, open up your Applications folder.baladeurs MP3 then open your World of Warcraft folder.buying gold world of warcraft For PC users, you'll need to open the My Computer folder from your Start Menu.mp3 mp4 From there.mp3 mp4 player open the hard disk that you have WoW installed on.wow level (Default is C:) Next, open the Program Files folder.mp3 player kaufen then locate your World of Warcraft folder.Now that you have opened the World of Warcraft folder.mp3 player kaufen you should see a folder named Interface.po wow Open up this folder and you will find the Addons folder.mp3 player kaufen This is the new home of your addons.wow lvl 60 This step is where some addons require some extra attention.wow lvl 70 Some addons.wow powerleveling like Atlas and Cartographer.wow gold come with multiple modules that work together.lotro gold but are located in different folders within the unzipped directory.lotro po Open up your unzipped addon folder and look for files with the .lua .toc file extension.wow levelExample: Atlas.lua Atlas.toc) Once you locate a file with the .toc extension. you can take the folder containing that file and move it into the Addons folder.

游客 [2008-07-08 10:45:49]