http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660How's that for support: while posting a follow-up post you were already posting the answer. Much thanks on both items. http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment14http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment14Tue, 10 Feb 2009 01:39:59 GMTIt appears that Niraj Bhatt has got batch size working with Oracle (see [nirajrules.wordpress.com/.../nhibernate-lessons...](http://nirajrules.wordpress.com/2009/01/27/nhibernate-lessons-learned/)) so I'll find out from him what, if anything, he had misconfigured initially. Will then post according in NH Prof Google group. http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment13http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment13Tue, 10 Feb 2009 01:38:34 GMTTed, 1/ the problem is with the way oracle's batches work. It wouldn't be reported as a batch in the profiler. 2/ I'll add one http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment12http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment12Tue, 10 Feb 2009 01:25:16 GMTFirst of all, within 10 minutes of profiling an app with NH Prof, I was able to discover an N + 1 select that none of my tests covered and in so doing uncovered a small typo that hadn't been caught at compile time or in any tests. Thank you for a great app! 1. I too am having difficulty getting the adonet.batch_size to work with Oracle. And yes, I'm using Oracle's driver (11g (11.1.0.6.20) with a 10g database). 2. I would love a keyboard shortcut to OPTIONS -> Clear I realize that support questions should likely go to the Google group, so will post there. http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment11http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment11Tue, 10 Feb 2009 01:10:31 GMTI can confirm that batching works on Oracle. Note that this is only using's Oracle's driver, not the system.data.oracle driver. http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment10http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment10Thu, 15 Jan 2009 10:13:07 GMTOops!!! I had missed inverse="true". Ayende this could be a good thing to be detected by Profiler. Also can you please confirm that statment batching works with Oracle? I am looking at a single call to DB with multiple queries which does Insert, delete, update. Somehow I am not able to achieve it. http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment9http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment9Thu, 15 Jan 2009 05:49:31 GMTSorry for the typo. I meant "when i try to insert a graph with one to many relationship, updates are followed by inserts. " http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment8http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment8Tue, 13 Jan 2009 11:33:28 GMTIt's not working with Oracle. I am using 10G & in the config file I have adonet.batch_size property to 16. I also tried setting batch-size at the class level but in vain. It still shows me all inserts seperate. One more aspect which confused me is when i try to insert a graph with one to many relationship, inserts are followed by updates. http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment7http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment7Tue, 13 Jan 2009 11:30:09 GMTI haven't really used nhib + ado.net batching in real apps due to the mismatch between this and versioning/opt locking (which I normally use for every aggregate). Are you aware of any good work around for this? http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment6http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment6Fri, 02 Jan 2009 00:25:39 GMTThomas, You are correct, and I'll change the name of this alert. Thanks for noticing this. http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment5http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment5Wed, 31 Dec 2008 14:52:14 GMTThis is a nice feature, but I would reconsider the name of this warning. If I remember correctly your other alerts state the problem in the name ("Too many database calls per session"), but this time you named the alert after the proposed solution ("Use statement batching"). This is bad in my eyes for a number of reasons: - It is inconsistent with the other warnings - A large number of writes may indicate a more fundamental problem, like deleting all child items in a collection and recreating them each time you add one item. - There are other solutions to reduce the number of writes to the database other than batching. For example for large bulk imports, you may want to use other options like SqlBulkCopy. Just my 2cts... http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment4http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment4Wed, 31 Dec 2008 14:02:13 GMTAyende, Happy New Year! I read your blog every day, and at least 30% of your posts are usefull for me, please write more and better next year Is there any chance to see a demo (5-10 minutes) of using NH Prof in sample hibernate application and removing select N+1 and other performance issues? If NHProf can find at least half issues - it is already usefull tool and comunity should have it in NHibernate package http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment3http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment3Wed, 31 Dec 2008 11:34:06 GMTIt works in Sql Server 2000 + and in Oracle. http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment2http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment2Wed, 31 Dec 2008 10:47:49 GMTisn't it something that works only with MS SQL Server 2005+ ? http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment1http://ayende.com/3786/nh-prof-alerts-use-statement-batching#comment1Wed, 31 Dec 2008 07:31:57 GMT