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

Michael Layne fx at 9degrees.com
Fri Jan 14 09:16:33 MST 2005


it does help.  thanks very much.

On Jan 14, 2005, at 11:14 AM, Chris Hansen wrote:

> 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
>>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>

Michael Layne  :  9 degrees development  :  www.9degrees.com  :  
404.226.7835
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 1433 bytes
Desc: not available
Url : http://www.iviking.org/pipermail/fx.php_list/attachments/20050114/1c2ef7dd/attachment.bin


More information about the FX.php_List mailing list