[FX.php List] get portal info or another 2 queries - no related data

[Chris Hansen]

Michael,

I'd say that it depends on what you're doing.  If you don't need all of 
the related data, do two queries.  On the other hand, if you're getting 
a detail on a record, and you've placed some information in a portal 
(so you'll be using all of the data), then it would be better to just 
access a layout with that portal on it.  HTH

--Chris Hansen
   creator of FX.php
   "The best way from FileMaker to the Web."
   www.iViking.org

On Jan 13, 2005, at 8:46 PM, Michael Layne wrote:

> A (hmmm...) straight forward question...
>
> I have several tables with related data in others.  Is 
> easier/faster/better to make 1 query and retrieve/parse possibly lots 
> of portal information (foreach...$relationship::field...) or make 2 
> instances of FX, getting less data from each table (layout)?
>
> May be a novice question!  Thanks!
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>