Mailing-List: contact open-jpa-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: open-jpa-dev@incubator.apache.org
Received-SPF: pass (asf.osuosl.org: domain of mprudhomapache@gmail.com
 designates 72.14.214.230 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:mime-version:in-reply-to:references:content-type:message-id:content-transfer-encoding:from:subject:date:to:x-mailer:sender;
        b=c4edEGW9f1xRC+gMt1sQhCg70yX0bV6Nh7yqCAPVUScSnHwqL424DJmmSoa86b6He+whaE+9eRBtfclqNs7TZn2l5H+zueIGt/3FgW8rX4Ew1/PzN5WHxl1rFj2qbFpBixPxaUsN5zrwB30BGOH+psqqjCg6940FDWW1NA4dpaM=
Mime-Version: 1.0 (Apple Message framework v752.3)
In-Reply-To: <49BF64BA795F6A498EC2F04F39BAA8D3D97EC4@ptint5.peacetech.com>
References: <49BF64BA795F6A498EC2F04F39BAA8D3D97EC4@ptint5.peacetech.com>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <CE81649D-1E5B-4FFF-8C8D-684D03982BB3@apache.org>
Content-Transfer-Encoding: 7bit
From: Marc Prud'hommeaux <mprudhom@apache.org>
Subject: Re: Why would Kodo refuse to batch inserts in certain tables? Big
 performance drop migrating to Kodo 4.1
Date: Mon, 16 Oct 2006 16:30:24 -0700
To: open-jpa-dev@incubator.apache.org
Sender: Marc Prud'hommeaux <mprudhomapache@gmail.com>

Alex-

So you are saying that batching is working OK in general, just not  
for a particular class? And that this particular class was batching  
fine with previous versions? That is odd, although there are some  
cases where we might refuse to batch a particular class (because of a  
driver bug with batching certain column types, etc).

As a shot in the dark, we do work around a bug in the Oracle JDBC  
driver's failure to batch date/time effectively.

Can you post the SQL log that shows the series of SQL statements that  
should have been batched, but weren't? That might help shed light on it.

Also, database and JDBC driver type/version would be useful.


On Oct 15, 2006, at 7:30 PM, Roytman, Alex wrote:

> Hello,
>
>
>
> While migrating to Kodo 4.1 I noticed significant drop in insert
> performance. I trace it down to some strange batching behavior. While
> most of the PC were committed with batched inserts one particular  
> class
> refused to batch and would insert row by row resulting in 10 times
> performance drop.
>
>
>
> There is nothing special about the class. Its hierarchy is mapped on
> base its table except for one of the lowest members which is mapped
> vertically.
>
>
>
>
>
> Thank you very much
>
>
>
> Alex Roytman
>
> Peace Technology, Inc.
>
> 301-206-9696x103
>
>
>