Return-Path: 
 <users-return-8100-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org>
Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org
Received: (qmail 18920 invoked from network); 10 Nov 2010 22:35:03 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 10 Nov 2010 22:35:03 -0000
Received: (qmail 74580 invoked by uid 500); 10 Nov 2010 22:35:34 -0000
Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org
Received: (qmail 74549 invoked by uid 500); 10 Nov 2010 22:35:34 -0000
Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@openjpa.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@openjpa.apache.org>
List-Post: <mailto:users@openjpa.apache.org>
List-Id: <users.openjpa.apache.org>
Reply-To: users@openjpa.apache.org
Delivered-To: mailing list users@openjpa.apache.org
Received: (qmail 74541 invoked by uid 99); 10 Nov 2010 22:35:34 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Nov 2010 22:35:34 +0000
X-ASF-Spam-Status: No, hits=3.5 required=10.0
	tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL,URI_HEX
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of michael.d.dick@gmail.com
 designates 209.85.213.46 as permitted sender)
Received: from [209.85.213.46] (HELO mail-yw0-f46.google.com) (209.85.213.46)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Nov 2010 22:35:27 +0000
Received: by ywc21 with SMTP id 21so140827ywc.33
        for <users@openjpa.apache.org>; Wed, 10 Nov 2010 14:35:06 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:mime-version:received:in-reply-to
         :references:from:date:message-id:subject:to:content-type;
        bh=TWDGmyfcsWAxEwd+nHuJnvQhDWHL+AMmtsXFM208ofY=;
        b=etYB+ue2ayQYrE9LxThE+MBKZj5nhs5AserngnVOVggi6dP9H9MfJBrmjFqdNV0I95
         I/xqxtQhSOvUGpLqOoIHvigJMBT73S0h+t93hpAYJ3P3zEJWvPweWMZHlwf5rVHzaYau
         x+OpWpoeyCH7ThKbGvjDDiZu0PP6F67H58nmg=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        b=dq/Nut+XQR7cWwDT87m9jANz5R0zCjHEfGeHR59mlG0/4fEtlOHhmvhWrGKWunyjxV
         P3jDPbFaRpryKeda5kcNgutBKJJqljdBM/vERlYWFr0Pzm7/m5IAwE7OuMFtMOKSJVQX
         KKlAVYoiEPpZqFYwrPahcJAFnonO/FKHQGvPQ=
Received: by 10.90.231.10 with SMTP id d10mr323097agh.44.1289428506705; Wed,
 10 Nov 2010 14:35:06 -0800 (PST)
MIME-Version: 1.0
Received: by 10.90.90.2 with HTTP; Wed, 10 Nov 2010 14:34:46 -0800 (PST)
In-Reply-To: <1289376291736-5723794.post@n2.nabble.com>
References: <1288606493590-5693298.post@n2.nabble.com>
 <1288801456667-5702044.post@n2.nabble.com>
 <AANLkTikqUpwxGBq7Qg+uLeEgiaN5859g8DXMF4YfMcuP@mail.gmail.com>
 <1289161933725-5715056.post@n2.nabble.com>
 <1289224638694-5716932.post@n2.nabble.com>
 <1289245977375-5718395.post@n2.nabble.com> <4CD8636E.7010108@oles.biz>
 <1289376291736-5723794.post@n2.nabble.com>
From: Michael Dick <michael.d.dick@gmail.com>
Date: Wed, 10 Nov 2010 16:34:46 -0600
Message-ID: <AANLkTikjd89YiPMh2JmuCsrqBz+ro5UnXNzF_hLfwqP0@mail.gmail.com>
Subject: Re: JPAB results
To: users@openjpa.apache.org
Content-Type: multipart/alternative; boundary=0016362851381b002b0494ba78d3
X-Virus-Checked: Checked by ClamAV on apache.org

--0016362851381b002b0494ba78d3
Content-Type: text/plain; charset=ISO-8859-1

Is it possible to create the tables manually before collecting performance
data? If so you could remove
     <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema"/>
from persistence.xml.

You'd need to do this for the other JPA providers as well, of course, but
removing the SyncMappings eliminates the table generation code which might
not be optimized for benchmarks. One would rarely use such a property in
production at any rate.

-mike

On Wed, Nov 10, 2010 at 2:04 AM, Ilan Kirsh <kirsh@objectdb.com> wrote:

>
> Thank you Georgi,
>
> If there are no more comments and suggestions I will use the following
> persistence.xml for the next run:
>
>
> <?xml version="1.0" encoding="UTF-8"?>
> <persistence xmlns="http://java.sun.com/xml/ns/persistence"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
> http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd" version="2.0">
>  <persistence-unit name="OpenJPA2-MySQL-server">
>
> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>    <class>org.jpab.basic.Person</class>
>    <class>org.jpab.col.CollectionPerson</class>
>    <class>org.jpab.ext.PersonBase</class>
>    <class>org.jpab.ext.PersonExt</class>
>    <class>org.jpab.ext.PersonExtExt</class>
>    <class>org.jpab.index.IndexedPerson</class>
>    <class>org.jpab.node.Node</class>
>    <properties>
>      <property name="openjpa.ConnectionProperties"
> value="DriverClassName=com.mysql.jdbc.Driver,
> Url=jdbc:mysql://localhost:3306/jpab4897789836, MaxActive=100,
> MaxWait=10000, TestOnBorrow=true, Username=admin, Password=admin,
> poolPreparedStatements=true"/>
>       <property name="openjpa.ConnectionDriverName"
> value="org.apache.commons.dbcp.BasicDataSource"/>
>      <property name="openjpa.jdbc.DBDictionary" value="batchLimit=100"/>
>      <property name="openjpa.DataCache" value="true"/>
>      <property name="openjpa.Log" value="DefaultLevel=ERROR"/>
>      <property name="openjpa.jdbc.SynchronizeMappings"
> value="buildSchema"/>
>    </properties>
>  </persistence-unit>
> </persistence>
>
> By the way, just a heads up - the benchmark site is being featured on
> JavaLobby:
>
> http://java.dzone.com/articles/new-jpa-performance-benchmark
>
> I have mentioned at the end that initial OpenJPA tuning work has produced
> better results.
>
> Best regards,
> Ilan
>
> --
> View this message in context:
> http://openjpa.208410.n2.nabble.com/JPAB-results-tp5693298p5723794.html
> Sent from the OpenJPA Users mailing list archive at Nabble.com.
>

--0016362851381b002b0494ba78d3--