[OJB-developers] "performance" target results against MySql

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi,

These are the results for the performance target against MySql.

------------------------------------------------------------------------
C:\Java\ojb-0.7.343>build performance
Buildfile: build.xml

init:

prepare:

main-opt:

tests:
     [move] Moving 1 files to C:\Java\ojb-0.7.343\src\test\setup
using switches: -HSQLDB, -ORACLE, -MS_ACCESS, -INSTANTDB, -DB2, =
-POSTGRESQL, +MY
SQL, -INFORMIX
.
     [move] Moving 1 files to C:\Java\ojb-0.7.343\src\test\setup
     [copy] Copying 1 files to C:\Java\ojb-0.7.343\build\test\setup
     [java] [BOOT] INFO: DB url:  jdbc:mysql://localhost:3306/ojbtest
     [java] [BOOT] INFO: Driver:  Mark Matthews' MySQL Driver
     [java] [BOOT] INFO: Version: 2.0.11

performance:
      [ojb] [BOOT] INFO: OJB.properties: =
file:/C:/Java/ojb-0.7.343/build/test/oj
b/OJB.properties
      [ojb] .[performance] INFO:
      [ojb] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
      [ojb] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
      [ojb] [performance] INFO: inserting 10000 Objects: 98902 msec
      [ojb] [performance] INFO: updating 10000 Objects: 105662 msec
      [ojb] [performance] INFO: querying 10000 Objects: 114755 msec
      [ojb] [performance] INFO: querying 10000 Objects: 89769 msec
      [ojb] [performance] INFO: fetching 10000 Objects: 12819 msec
      [ojb] [performance] INFO: deleting 10000 Objects: 79975 msec
      [ojb] [performance] INFO:
      [ojb] [performance] INFO: inserting 10000 Objects: 94426 msec
      [ojb] [performance] INFO: updating 10000 Objects: 108806 msec
      [ojb] [performance] INFO: querying 10000 Objects: 111200 msec
      [ojb] [performance] INFO: querying 10000 Objects: 36563 msec
      [ojb] [performance] INFO: fetching 10000 Objects: 11797 msec
      [ojb] [performance] INFO: deleting 10000 Objects: 80415 msec
      [ojb] [performance] INFO:
      [ojb] [performance] INFO: inserting 10000 Objects: 94056 msec
      [ojb] [performance] INFO: updating 10000 Objects: 105441 msec
      [ojb] [performance] INFO: querying 10000 Objects: 111100 msec
      [ojb] [performance] INFO: querying 10000 Objects: 41520 msec
      [ojb] [performance] INFO: fetching 10000 Objects: 12618 msec
      [ojb] [performance] INFO: deleting 10000 Objects: 79564 msec
      [ojb]
      [ojb] Time: 1,393.023
      [ojb]
      [ojb] OK (1 tests)
      [ojb]
     [jdbc] [BOOT] INFO: OJB.properties: =
file:/C:/Java/ojb-0.7.343/build/test/oj
b/OJB.properties
     [jdbc] .[performance] INFO:
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: inserting 10000 Objects: 36923 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: updating 10000 Objects: 38866 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: querying 10000 Objects: 88227 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: querying 10000 Objects: 88548 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: fetching 10000 Objects: 4847 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: deleting 10000 Objects: 35721 msec
     [jdbc] [performance] INFO:
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: inserting 10000 Objects: 35912 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: updating 10000 Objects: 38846 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: querying 10000 Objects: 85974 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: querying 10000 Objects: 87145 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: fetching 10000 Objects: 4947 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: deleting 10000 Objects: 34670 msec
     [jdbc] [performance] INFO:
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: inserting 10000 Objects: 36373 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: updating 10000 Objects: 38866 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: querying 10000 Objects: 86404 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: querying 10000 Objects: 85663 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: fetching 10000 Objects: 4958 msec
     [jdbc] [DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platform
MySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
     [jdbc] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
     [jdbc] [performance] INFO: deleting 10000 Objects: 35411 msec
     [jdbc]
     [jdbc] Time: 874.658
     [jdbc]
     [jdbc] OK (1 tests)
     [jdbc]

BUILD SUCCESSFUL

Total time: 38 minutes 9 seconds
------------------------------------------------------------------------

The results show that direct JDBC is 62.7% faster than OJB (against =
MySql):

      [ojb] Time: 1,393.023
     [jdbc] Time: 874.658

I think I found my problem....

:-(

Greetings,

Ricardo Arguello