Hi All,
Just my 2c: I've worked with Castor on a project for about a month. At
that stage the complexities of Castor became such a huge risk that we threw
everything out and moved to Torque/Peers.
We had 2 or 3 very complex queries for this particular system and while
Castor could do them the overhead was immense and it took more than a second
and dozens of database hits to complete.
With Torque on the other hand we had a mapping that was much closer to SQL.
With the handy row2Object() and resultSet2Objects() it was easy to do the
very complex queries by hand - reducing the result to milliseconds and a
single db hit.
We still used the normal O-R mapping in 99.99% of cases, but it is nice to
know that when the brown stuff hits the fan that you can tweak a complex
query by hand; and that you will still be able to channel the query through
your Object Model.
I my opinion counts for anything I would prefer that the ability to channel
raw SQL through your Object Model remains a part of Torque. This would
probably imply that Torque uses a relatively close mapping to SQL as opposed
to an abstract Object-Model.
~ Leon
> Hello,
>
> I've been playing with Torque for a few months now. I do like having
torque
> versus some other 'SQL' like model for a couple of reasons:
>
> 1) A developer does not have to be an expert in SQL.
>
> IMHO, A developer _should_ know SQL, but if you can provide an abstraction
> that doesn't _require_ them to know sql then all the better. Another
> advantage is the ability to write fewer lines of code. Torque/Turbine is
a
> big win here. I only have to deal with a Criteria object and a peer.
>
> 2) Long term the OM provides more flexibility.
>
> Peers are a fairly good abstraction. (IMHO) Using a "SQL" like object
> implementation might constrain you to thinking only about SQL and DB's.
I've
> not looked at the code too deeply but it might be possible to hind an
object
> model behind an RMI (or something similar) implementation.
>
> Take Care
> Jason Kary
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
