I've created a simple object such as
class Person
{
int id;
String name;
}
I used the following code to measure the update speed (again, I need to
test for one transaction on one create())
for(int c=0;c<MAX_OBJECTS;c++)
{
person = new Person();
person.id = c;
person.name = "name-" + new Integer(c).toString();
db.begin();
db.create( person );
db.commit();
}
The speed was roughly 6 objects / sec.
Then I run the following code:
for(int c = 0;c < MAX_OBJECTS; c++)
{
execute("insert into test (id,value) values (" + c + ", 'name-" + c
+ "')");
execute("commit");
}
where the method <execute> simply executes an sql Statement with the
argument string. This test could give me 180 row inserts /sec.
I have also made tests for large, complex objects. It turned out that
larger objects don't need proportionally longer time.
Did anyone get other results?
Thanks in advance,
Norbert
> > I am using the pre-compiled, downloadable castor-0.9.3 version. I've
> > made some tests with JDO on small object updates / queries / deletes
> > testing single transaction speed. Comparing the results with the
> > same amount of data transfer directly using JDBC (therefore
> > eliminating > the object<->table mapping overhead and simply
> > executing insert / > delete / select SQL commands), I've measured
> > about 30 times more > performance.
>
> Would you provide more details about the tests you ran and your
> results?
>
> Thanks
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
