db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bill Schneider <bschnei...@vecna.com>
Subject Re: Examples of Torque based solutions
Date Sun, 16 Feb 2003 16:51:09 GMT

We've been using Torque commercially for similar types of applications:
read-intensive JSP front ends, frequent but simple queries with small result
sets, and not too many db writes.  We've used it successfully as a runtime
O/R mapper in a telemedicine consultation system, a system for on-line
medical appointments, and a timesheet entry/reporting system.

In general Torque is a win for this type of application because it gets a
framework for db reads and writes up and running quickly.  Torque starts to
break down when your queries get complex--once you get beyond a simple
find-by-key or find-by-value test, the SQL might be a lot simpler than the
right Criteria object.

Also, as your load increases, bind variables become imperative, so you don't
hose the database with parsing and compiling the same queries repeatedly.
Torque has some support for bind-variable based queries but doesn't make it
easy.  Still, Torque has still held up better for us in terms of both
performance and stability than comparable systems with EJB CMP.  Until a
system reaches critical mass of size or complexity, the overhead of entity
beans is a lose.  Torque often wins because it's simple and lightweight.  I
am also eager to try out OJB to compare.

One important thing to keep in mind with JSP apps is to be careful if you
session-scope any Torque objects for performance reasons.  It's critical to
remember the Torque objects only contain a snapshot of the persistent state
when the object was instantiated.  Different sessions might have a different
snapshot of the same row which could diverge and potentially clober each
other when re-saved.  Especially if you have a multi-JVM cluster.  This is
generally not a problem as long as you use session-scoping with caution.

-- Bill
----- Original Message -----
From: "Steve Hansen" <steve.hansen@sinex.com>
To: "Torque_user_list" <torque-user@db.apache.org>
Sent: Saturday, February 15, 2003 9:53 AM
Subject: Examples of Torque based solutions

> Hello,
> I've been using Torque for about 3 months now and I'm very pleased with
> the software.  I'm trying to get it's use expanded in our company's
> products.  The question came up of where else is Torque being used?  The
> concerns are scalability and stability. Has Torque been stressed by an
> application placing heavy IO demands on the database.
> Our database use profile is that of a fairly small number of users 75 -
> 150, working against a Web JSP front end, generating large data demands
> for reports with a modest amount of insert and update activity against a
> dedicated database server.
> How are you using Torque? The examples you give will help me convince
> management of the value of Torque.
> Thanks
> Steve Hansen
> Solutions Engineer
> Sinex Aviation Technologies
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org

View raw message