db-torque-user mailing list archives

I'm working with Torque 3.1 and I need to catch a List of ids of a table
of customers ( I only need their ids). That table can have thousands of
rows, and each row has a lot of columns, so using Criteria to catch a
list of thousands of customer objects is very inefficient and very,
very, slow. I only need the ids of a query like this "select id from
customer where money>500" .
How ( and Where ) can I develop a method that execute that query and
return only a list of ids without having to retrieve a list of objects?
Which is the best solution?
Thank you very much!
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org