openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Dick <michael.d.d...@gmail.com>
Subject Re: JPAB results
Date Wed, 10 Nov 2010 22:34:46 GMT
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.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message