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 ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
