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