TweetFollow Us on Twitter

FileMaker's 7 "biggest" change (And it seems to be a secret!)

Volume Number: 21 (2005)
Issue Number: 4
Column Tag: Review

FileMaker's 7 "biggest" change (And it seems to be a secret!)

by Neil Ticktin


To say FileMaker 7 is a significant upgrade from FileMaker 6 is a major understatement. As you will see when your read the FileMaker 7 Developer review in this issue of MacTech, (Page 38, What's New In FileMaker 7) 7 allows for real relationships, has a better set of tools, and offers major enhancements across the board.

As a FileMaker user since FileMaker Plus, I'm excited about one change that not a lot People seem to know about, but could well be the biggest change in FileMaker since it went multi-user ... and that is how FileMaker Server now deals with remote users.

It used to be that all the heavy lifting in FileMaker -- calculations, sorting, etc... all took place on the client end. But, with FileMaker 7, the processing has been moved to the server, (where it belongs) and all the client receives is the relevant data. This is a huge shift, and will allow FileMaker to be deployed in ways it never could before. Let me explain.

Let's use an example of a sort or calculation in FileMaker. In FileMaker 6 and prior, FileMaker Server would send little bits of information, one piece at a time, to the client. The client would dutifully respond to the server confirming the data. While some would say "Why do I care? I've got a T1 and plenty of bandwidth!", that's not what's relevant. The real issue here is not bandwidth, but latency. When little bits of data are sent, and then confirmed, back and forth, back and forth, back and forth ... you end up with a type of behavior known as "thrashing".

Now, if you are on a LAN with 5 milliseconds or less latency, it doesn't matter. But if you are closely tied (maybe the next building), you may see 20ms latency, or on a good Internet connection, maybe 80-100ms. God forbid that you were on a DSL or cable modem connection with 200-300ms latencies.

Since milliseconds are thousandths of a second, this seems petty -- but, it's not. We put FileMaker 7 to a typical MacTech-style real world test. We moved a good size database (about 50,000 records total, making up about 110 MB) from FileMaker 6 to 7, and deployed it with both local users, and users across the country over the Internet.

The end result was we found FileMaker 7 to be significantly faster. Much more important than just some random bench test or statistic, 7 ended up moving us from a situation where the system was just too slow to use to one that is now very usable.

We'll keep this short and sweet -- and give you two extremes of the testing that we did. The first test is a relatively simple test: opening files, running basic scripts, etc... The second test is a brutal report that even locally takes over 10 min to run.

                    FileMaker 6   FileMaker 7 
                     hr:min:sec    hr:min:sec
Simple test                3:00          1:34 
Complex report          1:27:04         12:32

End result? Well appropriately so, FileMaker 7 is more than 7 times faster than FileMaker 6 when it comes to sharing databases over the Internet.

Porting from FileMaker 6 to 7 did have its issues. There were some scripts that broke, we had to learn to reference the table and the field, not just the field (because FileMaker is now relational). In short, it did take effort ... but from what we can see, it's well worth the effort. We look forward to moving our multi-file databases that have pseudo-relationships and glue files to a single file, to a true multi-table solution and take advantage of many of the other new features of FileMaker 7.

If your mind isn't cranking on all the new possible uses, it should be. Go get to it!


Neil Ticktin is the publisher of MacTech Magazine.

 

Community Search:
MacTech Search:

Software Updates via MacUpdate

Latest Forum Discussions

See All

Top Mobile Game Discounts
Every day, we pick out a curated list of the best mobile discounts on the App Store and post them here. This list won't be comprehensive, but it every game on it is recommended. Feel free to check out the coverage we did on them in the links... | Read more »
Blue Archive heads for nature in New Yea...
Continuing the Blue Archive trend of releasing seasonal events to the Western version of the game nowhere near when they actually happened, the Cyber New Year March update has arrived. It brings with it a story centring around New Year, which it... | Read more »
Once Human conquers maths to be one hotl...
It feels like Once Human has been in development for about ten years at this point, but that has clearly not blunted the excitement for NetEases’ upcoming open-world survival game. As a matter of fact, it seems things have never been better, as... | Read more »
Watcher of Realms celebrates its first a...
It has been one year since Moonton Games kicked off the fantasy RPG Watcher of Realms, and there are a lot of celebrations to mark the occasion. You could take part in a brand-new mode, earn some skins, and recruit some of the strongest characters... | Read more »
Tarisland finally launches and celebrate...
It has felt like a lifetime, as it always does when it comes to waiting, but now Level Infinites’ anticipated MMORPG Tarisland is available across mobiles and Windows. It is time to pick your favourite of the nine classes, customise them to your... | Read more »
Reverse: 1999 offer Reality teams a mout...
Bluepoch Games has confirmed that Phase 2 of Reverse:1999s Version 1.6 has launched, and brings with it a lot to get your teeth into. Along with some sign-in rewards and a bunch of stories to enjoy, as well as a new 6-star character who just might... | Read more »
Uncharted Waters Origin unveils its late...
LINE Games, Motif, and KOEI Tecmo have announced the latest raft of updates for their seafaring adventure title Uncharted Waters Origin, and if you've played for a while you know what to expect. A new Admiral, new mates, and some new story, the... | Read more »
Wrecking Golf is a casual physics-based...
In case you missed it, Dusan Popovic has officially launched Wrecking Golf on iOS and Android, the indie developer's casual golf game on mobile presented with charming pixel-art visuals. Featuring physics-based mechanics and simple controls, the... | Read more »
Blue Archive is striking out to Anime Ex...
At this point in my writing career, I have seen quite a few press releases come about, and it feels like one of the most frequently updated games there is Blue Archive. It is, of course, great to see a game have a life like this, and now Nexon is... | Read more »
Grab a Grammy-inspired Backbone One with...
There are so many mobile controllers on the market that it could be a little difficult to know which to go for. If you are someone who goes for a good old celebrity endorsement, however, then the new Backbone One might be for you, created as it... | Read more »

Price Scanner via MacPrices.net

Walmart continues to sell clearance 13-inch M...
Walmart continues to offer clearance, but new, Apple 13″ M1 MacBook Airs (8GB RAM, 256GB SSD) online for $699, $300 off original MSRP, in Space Gray, Silver, and Gold colors. These are new MacBooks... Read more
Apple is offering steep discounts, up to $600...
Apple has standard-configuration 16″ M3 Max MacBook Pros available, Certified Refurbished, starting at $2969 and ranging up to $600 off MSRP. Each model features a new outer case, shipping is free,... Read more
Save up to $480 with these 14-inch M3 Pro/M3...
Apple has 14″ M3 Pro and M3 Max MacBook Pros in stock today and available, Certified Refurbished, starting at $1699 and ranging up to $480 off MSRP. Each model features a new outer case, shipping is... Read more
Amazon has clearance 9th-generation WiFi iPad...
Amazon has Apple’s 9th generation 10.2″ WiFi iPads on sale for $80-$100 off MSRP, starting only $249. Their prices are the lowest available for new iPads anywhere: – 10″ 64GB WiFi iPad (Space Gray or... Read more
Apple is offering a $50 discount on 2nd-gener...
Apple has Certified Refurbished White and Midnight HomePods available for $249, Certified Refurbished. That’s $50 off MSRP and the lowest price currently available for a full-size Apple HomePod today... Read more
The latest MacBook Pro sale at Amazon: 16-inc...
Amazon is offering instant discounts on 16″ M3 Pro and 16″ M3 Max MacBook Pros ranging up to $400 off MSRP as part of their early July 4th sale. Shipping is free. These are the lowest prices... Read more
14-inch M3 Pro MacBook Pros with 36GB of RAM...
B&H Photo has 14″ M3 Pro MacBook Pros with 36GB of RAM and 512GB or 1TB SSDs in stock today and on sale for $200 off Apple’s MSRP, each including free 1-2 day shipping: – 14″ M3 Pro MacBook Pro (... Read more
14-inch M3 MacBook Pros with 16GB of RAM on s...
B&H Photo has 14″ M3 MacBook Pros with 16GB of RAM and 512GB or 1TB SSDs in stock today and on sale for $150-$200 off Apple’s MSRP, each including free 1-2 day shipping: – 14″ M3 MacBook Pro (... Read more
Amazon is offering $170-$200 discounts on new...
Amazon is offering a $170-$200 discount on every configuration and color of Apple’s M3-powered 15″ MacBook Airs. Prices start at $1129 for models with 8GB of RAM and 256GB of storage: – 15″ M3... Read more
Amazon is offering a $200 discount on 14″ M3...
Amazon has 14-inch M3 MacBook Pros in stock and on sale for $150-$200 off MSRP. Shipping is free. Note that Amazon’s stock tends to come and go, so be sure to check their site often if the model you... Read more

Jobs Board

Solutions Engineer - *Apple* - SHI (United...
**Job Summary** An Apple Solution Engineer's primary role is tosupport SHI customers in their efforts to select, deploy, and manage Apple operating systems and Read more
*Apple* / Mac Administrator - JAMF Pro - Ame...
Amentum is seeking an ** Apple / Mac Administrator - JAMF Pro** to provide support with the Apple Ecosystem to include hardware and software to join our team and Read more
Operations Associate - *Apple* Blossom Mall...
Operations Associate - Apple Blossom Mall Location:Winchester, VA, United States (https://jobs.jcp.com/jobs/location/191170/winchester-va-united-states) - Apple Read more
Cashier - *Apple* Blossom Mall - JCPenney (...
Cashier - Apple Blossom Mall Location:Winchester, VA, United States (https://jobs.jcp.com/jobs/location/191170/winchester-va-united-states) - Apple Blossom Mall Read more
Omnichannel Associate - *Apple* Blossom Mal...
Omnichannel Associate - Apple Blossom Mall Location:Winchester, VA, United States (https://jobs.jcp.com/jobs/location/191170/winchester-va-united-states) - Apple Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.