this is the commands:
session.SetBatchSIze(100);
ITransaction transaction = session.BeginTransaction()
session.save(auditEntry); //add about 2000 of these
session.Flush();
in my config;
<add key="adonet.batch_size" value="1" />
this is my mapping file
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" >
<class name=".Persistence.Audit.AuditEntry, Persistence"
table="AUDIT_LOG" >
<id name="Id" column="id">
<generator class="native"/>
</id>
<property name="Message" column="message"/>
<property name="EntityId" column="entityId"/>
<property name="EntityType" column="entityType"/>
<property name="EntityName" column="entityName"/>
<property name="CommitPointName" column="commitPointName"/>
<property name="CommitPointDescription"
column="commitPointDescription"/>
<property name="FieldName" column="fieldName"/>
<property name="OriginalValue" column="originalValue"/>
<property name="NewValue" column="newValue"/>
<property name="Created" column="created"/>
</class>
</hibernate-mapping>
As far as I know this is what I need to get batched inserts but I
still dont, is there something Im missing.
thanks
scott
On Aug 20, 3:57 pm, Fabio Maulo <[email protected]> wrote:
> I would be sure of what you are using.Please send here (using copy&paste)
> the NH configuration and the id-mapping of each entity involved in what you
> are testing.
>
> 2009/8/20 srf <[email protected]>
>
>
>
>
>
>
>
> > no, Im using Guids as the Id, should that effect trying to do batched
> > inserts?
>
> > thanks
>
> > scott
>
> > On Aug 20, 11:03 am, "Cesar Sanz" <[email protected]> wrote:
> > > Are you using auto-incremental ids?
>
> > > ----- Original Message -----
> > > From: "srf" <[email protected]>
> > > To: "nhusers" <[email protected]>
> > > Sent: Thursday, August 20, 2009 7:55 AM
> > > Subject: [nhusers] batch_size
>
> > > > I was tying out the nhProf and it was saying one optimization it was
> > > > mentioning was to use batching. For example , in one session I was
> > > > inserting 2000 records into the audit_log table and I was doing 2000
> > > > seperate insert statements and it mentioned to us the setBatchSize
> > > > command so I used that then I got a message that I needed to set the
> > > > ado.Batch_size too so I did that and all was well but I didnt notice
> > > > any performance diference so I re ran the nhprof again. It again said
> > > > to set the batch size since it was still generating 2000 insert
> > > > statements so setting the batch size didnt seem to do anything. I did
> > > > some searches and found other people who set the batch size without it
> > > > having any effect. Could it be something with the sqlserver driver? Im
> > > > using the sql server 2005 dialect and im hitting sql server 2008 .
> > > > Also Im running 64bit if that matters.
>
> > > > Is there anyone else that had this problem as was able to solve this?
>
> > > > thanks
>
> > > > scott- Hide quoted text -
>
> > > - Show quoted text -
>
> --
> Fabio Maulo- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
