Re: [CDBI] What is the best way to search for record of table based on criteria of a field of its child table?

[prev] [thread] [next] [Date index for 2006/01/06]

On Fri, 2006-01-06 at 13:11 -0500, Sai Tong wrote:
> What is the best way to search for records of table A based on criteria 
> of a field of its child table like table B?

The best in terms of speed is to use a join via set_sql.  See the joins
page on the wiki.

- Perrin


_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi