[FX.php List] Re-FileMaker Server 12

[Bob Patin]

On Apr 5, 2012, at 12:14 AM, Malcolm Fitzgerald wrote:

> 
> On 05/04/2012, at 2:57 PM, Bob Patin wrote:
> 
>> I rarely use portals in web-accessed layouts.
> 
> Interesting. I'm finding that web interaction is leading me to use greater degree of normalisation in my filemaker databases. That means relationships.

I didn't say that I don't use related tables; of *course* I use related tables. I prefer to do separate queries for related records in almost all cases. Last I heard, there was no quantifiable data that said that one was faster than the other; I prefer going to the related table's layout and doing my query there. 

If there are a few related fields that I need, sometimes I'll put that within the first query, but generally I prefer to break it out, and haven't seen it to be slower than passing a TON of data through one query.

Bob Patin
Longterm Solutions LLC
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
FileMaker 9, 10 & 11 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--
Twitter: bobpatin
Google+: http://www.longtermsolutions.com/plus
AIM: longterm1954
iChat: bobpatin
--
Expert FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker

Bob Patin
Longterm Solutions LLC
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
FileMaker 9, 10 & 11 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--
Twitter: bobpatin
Google+: http://www.longtermsolutions.com/plus
AIM: longterm1954
iChat: bobpatin
--
Expert FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker