I figured it. I was doing something real dumb. At the command-line I was
testing db2 and not hsqldb.
The real problem is that I when I converted all my long update transactions
into short transaction, I was loading each record one at time. I now load
all the objects into the transactions and then do the update. Now it is
faster than the inserts.
userScenario.jdoUpdate() {
:
final OQLQuery oql = _db.getOQLQuery( "select w from
com.opendemand.jdo.WebResource w where userScenario = $1 ");
// do the upate for objects
:
}
db = getJDO().getDatabase();
db.begin();
db.update(userScenario);
db.commit();
----- Original Message -----
From: "Stephen Ince" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 27, 2004 6:35 PM
Subject: Re: [castor-dev] tomcat/hsqldb/castor configuration help
>
> I have explicitly set any logging stuff, at least not for castor. I am
> really stumped by this.
>
> Steve
> ----- Original Message -----
> From: "Stein M. Hugubakken" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 27, 2004 5:51 PM
> Subject: Re: [castor-dev] tomcat/hsqldb/castor configuration help
>
>
> >
> > Stephen Ince wrote:
> > > Has anyone done any tomcat 4.1.x/apache DB common 1.1 /hsqldb/castor?
I
> would like to take a look at your database configuration for your webapp.
I
> seem to have a update performance problem. I have an object that makes
> 10,000 database updates. When I update the object at the command line it
> does fine, 0-10 milliseconds per update. When I update the object through
> the webapp running on Tomcat I degrade to 100-150 milliseconds per update.
> The only difference is tomcat. In both cases I am using
> org.apache.commons.dbcp.BasicDataSource for a datasource. The inserts into
> database are a lot faster, 0 - 10 milliseconds.
> > >
> >
> > It sounds like it's logging set to debug, does that give you any hints
> > where to look?
> >
> > Stein
> >
> > -----------------------------------------------------------
> > If you wish to unsubscribe from this mailing, send mail to
> > [EMAIL PROTECTED] with a subject of:
> > unsubscribe castor-dev
> >
> >
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
>
