Databases
StackOverflow2013
Postsdbo
PONHibernate + Oracle: speed problems when querying data
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONHibernate + Oracle: speed problems when querying data
    primarykey
    data
    text
    <p>We have an WCF application which uses NHibernate to query data from the database. After installing the application into a new test environment we're facing some performance problems with queries. Our old and new environment use different Oracle-servers but both of the databases have the same data.</p> <p>We have went through our NHibernate logs and identified the problematic part:</p> <pre><code>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 </code></pre> <p>In this case the query returned one row. But it seems that in our new environment the "processing result set" is taking much longer (5 seconds vs 0.5 seconds) than in our other environment. Is there some way to find out exactly what inside the "processing result set" is taking so long?</p> <p><strong>Note.</strong> Executing the same exact query directly into the DB with Toad doesn't reproduce the problem. <strong>With Toad, both database server are equally fast.</strong> </p> <p>We are using DetachedCriteria to create the query and then it is executed like this:</p> <pre><code> Dim criteria As ICriteria = crit.GetExecutableCriteria(GetSession()) Return New Generic.List(Of T)(criteria.List(Of T)) </code></pre> <p>The version of NHibernate is 2.1.2.4 and we're using ActiveRecord 2.1.0 to create the mappings. Oracle servers are of version 10g.</p> <p>So in our case we have two environments that have the same version of the application with identical configuration files and are querying against identical databases, but which have different application and oracle servers. <strong>In one environment querying through the NHibernate takes around 5.5 seconds and in the another 0.5 seconds.</strong> The results are consistent and the same query has been executed around 50 times to both environments. </p> <p>Is there something in the Oracle configuration which could cause it to misbehave with NHiberate? And is there a way to get more detailed logging out from NHibernate so that the exact problem inside the "processing result set" could be found?</p> <p>Any advice is greatly appreciated.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USMikael Koskinen
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PONHibernate + Oracle: speed problems when querying data
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PONHibernate + Oracle: speed problems when querying data
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHard to say.. Couldn't there be some network bottleneck between the new test environment and db server? Did you try to run Toad from the WCF server?
      singulars
      1. PONHibernate + Oracle: speed problems when querying data
      1. USDenis Ivin
    2. COTo eliminate the database as the cause you could trace the session and compare the results on old and new. Could be that sql developer explicitly sets session parameters wich default to different values on new and old database.
      singulars
      1. PONHibernate + Oracle: speed problems when querying data
      1. USRobert Merkwürdigeliebe
    3. COThank you both for your comments. We were finally able to sort things out by switching the drivers.
      singulars
      1. PONHibernate + Oracle: speed problems when querying data
      1. USMikael Koskinen
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload