Hey, After learning some ANT basics i have managed to enhance my classes using the ant script :-)
In each of my tests i have 10,000 iterations and at the end i calculate the average execution time. Insert/Update & Delete results are reasonable.. about 1.5x than plain JDBC. But, Select (EntityManager.find()) performs pretty slow 2x and more than plain JDBC. Some details about my environment: Client and Server are on different machines on my local network. The properties i have in my persistence.xml file are: <property name="ConnectionProperties" value="DriverClassName=com.mysql.jdbc.Driver, Url=jdbc:mysql://......., MaxActive=100, MaxWait=10000, Username=..., Password=..., TestOnBorrow=false, poolPreparedStatements=true" /> <property name="jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/> <property name="ConnectionDriverName" value="org.apache.commons.dbcp.BasicDataSource"/> <property name="openjpa.Multithreaded" value="true" /> <property name="jdbc.DBDictionary" value="batchLimit=1000"/> -- View this message in context: http://openjpa.208410.n2.nabble.com/OpenJPA-MySQL-performance-overhead-tp5279410p5292574.html Sent from the OpenJPA Users mailing list archive at Nabble.com.