two things:1- To have batcher working you should set adonet.batch_size="100" 2- That "native" smell bad (in MsSQL native=identity and it nullify the batcher)...
where is the "guid" you have mentioned ? 2009/8/21 srf <[email protected]> > > 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 - > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
