Using same session (at least th. I have now done a bit more monitoring. And it seems that the CPU and memory load is increasing over time while the actual disc writes does not. Also the performance of the database server does not seem to change when monitoring the database directly while the application is running.
On 17 Mar, 11:07, Ayende Rahien <[email protected]> wrote: > Are you using the same session? Or creating a session every time? > > On Tue, Mar 17, 2009 at 11:31 AM, Utopico <[email protected]> wrote: > > > I have used hibernate for about half a year, but not with very high > > load. Yesterday I had an application running that slowed down > > significantly after running through the night (from fraction of a > > second to 10-15 seconds). I am pretty sure that there is somthing can > > be done to improve this, or a way to find out what is the cause. I > > need some help with this. > > > So for my application > > * I use NHibernate 2.0.0.GA > > * Visual studio 2008 > > * FirebirdSQL 2.0 > > * received data every 15 seconds on a serial port which is then > > decoded. This results in: > > - check for datatype (cached query through SysCache since these > > values are updated seldom, but checked often) and possible addition of > > new datatype entry (each datavalue has a datatype associated with it) > > - using sequence generator for ID on datavalue and dataobject > > - insert of a dataobject which has about 120 values associated as > > follows (results in one dataobject insert and 120 inserts: > > [NHibernate.Mapping.Attributes.Bag(Table = "DATA_VALUE", > > Inverse = true, Lazy = true, OrderBy = "TYPE_ID ASC, IDX ASC", Cascade > > = "all-delete-orphan")] > > [NHibernate.Mapping.Attributes.Key(1, Column = "REC_ID")] > > [NHibernate.Mapping.Attributes.OneToMany(2, ClassType = typeof > > (Nortek.SeaState.Domain.DataValue))] > > public virtual IList<DataValue> Values > > { > > get > > { > > return this._values; > > } > > set > > { > > this._values = value; > > } > > } > > * All the above is inclosed in a transaction with ReadCommited > > > Would I benefit from batch inserts or any other performance trick? Or > > is there some stupid flaw in my way of using hibernate? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
