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 <[email protected]> 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.
>
