Jan 25 - What’s Faster
Overview. Jason Young of MightyData LLC will be speaking.
“What’s Faster”
As FileMaker developers, we know that there are often several different methods to accomplish the same task. Is there a significant difference in the performance of these methods? As we continuously try to improve the solutions we deliver, we need to examine some conceptions (and misconceptions) of what really is faster. Some of these common operations have been put through actual time trials. In this session we’ll review the different methods used, as well as their results. In doing so, we’ll establish some standards for developing solutions that perform with optimal speed, as well as a methodology we can use for future comparisons.
Jason Young is a certified FileMaker developer and FileMaker authorized trainer. He has been working with MightyData LLC since the summer of 2009. Previously, Jason had been working with FileMaker as both an in house developer and consultant since the early part of the decade. Jason began his career in the manufacturing world, but as with many developers, continues to expand his experience into new industries. In 2007 Jason became a FileMaker authorized trainer, and has taught multiple classes in Seattle and Dallas, as well as being a regular contributor to the Seattle chapter of FMPug.
 Jason Young MightyData LLC |
Questions?
Leave a comment below and we’ll get it to Jason to make sure he gets to it…
5 Comments
Bruce Robertson on January 26th, 2010
I mentioned non-recursive large-list custom functions at the meeting. Claims are up to 500k - 1M. There are two authors, and a few variations, you can search the Brian Dunning list for Agnes & Debi.
Examples:
http://www.briandunning.com/cf/899
http://www.briandunning.com/cf/868
Bruce Robertson on January 26th, 2010
From my test file with 200k records, desktop file (no server)
List function: 13 seconds
Applescript: 7 seconds
Copy all records: 16 seconds
Bruce Robertson on January 26th, 2010
Loop with batch accumulator: 11 seconds
Jason Young on January 27th, 2010
Thanks Bruce I’ll definitely look at this stuff for the devcon version.
I did test the off screen window and itty bitty window and once the window is frozen there is no difference. Basically freeze window gives you the same benefit you get from the other two methods.
John Weinshel on January 24th, 2010
I loved your POE session, but it sadly makes it unlikely I’ll make it Monday. Nonetheless, it seemed like your next step was to host your file from a server and compare the results to running local. I’m guessing you’ve stayed in the NW and don’t have access to decent equipment. If you’d like, and if it is just a matter of throwing the file up and running it overnight, I’d be happy to do so and send it back to you in the morning. Dell PE 1800 running FMSA 10, custom build XP client with a lot of horsepower. The server is just used for development and probably less powerful than one used in a stressful deployment, but it might give you at least some answers to Monday nights’s ineveitable questions.