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
-~----------~----~----~----~------~----~------~--~---
