[FX.php List] Workaround for Portal Bug in Recent Versions of FMS

[Malcolm Fitzgerald]

Beverly,

Don't you find that the need to make multiple connections imposes time 
penalties?

I began doing all the work, ie, query parent, query related tables, but 
I'm now putting portals onto layouts and getting better performance. 
Admittedly, this is done on small related record sets.

Malcolm

On 25/01/2015 12:41 pm, Beverly wrote:
> Yes. Query and display the parent. Query and display as many "portals" as needed by taking the parent primary key to match the child foreign key.
>
> -- sent from myPhone --
> Beverly Voth
> --
>
>> On Jan 24, 2015, at 2:10 PM, Philip Lamb <phil at eden.net.nz> wrote:
>>
>> Beverly,
>>
>> Can you explain a little more about this technique? I used portal fields as a convenient way to query multiple tables with a single query. Do you make multiple requests using the foreign key technqiue?
>>
>> Regards,
>> Phil.
>>
>>> On 24/01/2015, at 5:47 AM, BEVERLY VOTH <beverlyvoth at gmail.com> wrote:
>>>
>>> I tend to skip portals altogether on the web and just get the data using the foreign key. Which is another option for those who hate the portal-bug. :)
>> _______________________________________________
>> 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