NHibernate + Oracle: speed problems when querying data -


we have wcf application uses nhibernate query data database. after installing application new test environment we're facing performance problems queries. our old , new environment use different oracle-servers both of databases have same data.

we have went through our nhibernate logs , identified problematic part:

2010-12-02 07:14:22,673 nhibernate.sql                 - select this_.cc... 2010-12-02 07:14:22,688 nhibernate.loader.loader       - processing result set 2010-12-02 07:14:27,235 nhibernate.loader.loader       - result set row: 0

in case query returned 1 row. seems in our new environment "processing result set" taking longer (5 seconds vs 0.5 seconds) in our other environment. there way find out inside "processing result set" taking long?

note. executing same exact query directly db toad doesn't reproduce problem. with toad, both database server equally fast.

we using detachedcriteria create query , executed this:

        dim criteria icriteria = crit.getexecutablecriteria(getsession())         return new generic.list(of t)(criteria.list(of t))

the version of nhibernate 2.1.2.4 , we're using activerecord 2.1.0 create mappings. oracle servers of version 10g.

so in our case have 2 environments have same version of application identical configuration files , querying against identical databases, have different application , oracle servers. in 1 environment querying through nhibernate takes around 5.5 seconds , in 0.5 seconds. results consistent , same query has been executed around 50 times both environments.

is there in oracle configuration cause misbehave nhiberate? , there way more detailed logging out nhibernate exact problem inside "processing result set" found?

any advice appreciated.

we able fix our problem switching database drivers microsoft's oracle's odp.net. now, both servers equally fast , our fast server executes queries more rapidly. don't know setting in our new server made microsoft's oracle driver slow.

and seems microsoft nowadays recommending use else own oracle-drivers. http://blogs.msdn.com/b/adonet/archive/2009/06/15/system-data-oracleclient-update.aspx


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use
Read more