[SQLObject] select only specified columns

[Imre H. <ble...@gm...>]

Hi everyone!

Is it possible to select only a few columns from a table?
My primary problem is speed when i select all rows from a big table (>1
mill. record).
But i only need 2-3 columns from it. I think it's because all other
columns & related objects are selected.

FYI: The exact scenario is:
Customers table: id, name, lots of other data.
For a master/detail form, i need to fill the list with id and name only.
When the user selects a row in the list, i get the customer object via
id, and fill the details form.

Thanks for advance:
Imre Horvath