+1
VIEW is, IMHO, en excelent way to go, when the SQLObject is close to its limits.

Petr


On 1 July 2010 18:28, Oleg Broytman <phd@phd.pp.ru> wrote:
On Thu, Jul 01, 2010 at 03:48:38PM +0000, Mark wrote:
> Even if you weren't using SQLObject I believe it would make more
> sense to create a separate name/id table and then only select
> from the 40 column table when you know what row you want.

  Or use a VIEW.

Oleg.
--
    Oleg Broytman            http://phd.pp.ru/            phd@phd.pp.ru
          Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss