I have discovered over the last few years … I am one of those people that can’t stand dull knives ( they drive me nuts ), loves to park backwards, and loves to measure things. A recent article in Arstechnia ( that has nothing to do with FileMaker ), caught my eye because of this statement at the begging of the article.
"That means that when you want to think about what to do next, you need to consider how a measurement can be made more sensitive."
It caught my eye because many times when we say want want to improve something, then we need a way to measure it. Mark Scott wrote a great blog post not too long ago titled: Performance Optimizations Make Compelling Case for FileMaker 15 Upgrade
And you guessed it, he needed some way to measure it. Fortunately for Mark, he doesn’t need to measure small things like Protons but unfortunately there still is no built in way to measure anything with FileMaker. And from my point of view this is a big disappointment when your a developer and need to know, among the many development decisions you are constantly making, that next decision is going to be your undoing.
- Adding that unstored calculation to your portal
- Using a value from a table that is 6 hops away
- Not fully taking advantage of what Perform Script on Server can do
Its not to say that we have common sense and I would know better to not put an unstored calculation in a portal. And with the improvements in FileMaker 15 it would not matter much anyway. But the point I am trying to make is that as a community this is a must. Especially if FileMaker takes the community seriously and wants us to build top quality solutions then a comprehensive built in way to measure things would be a huge benefit to the community.
As developers we are constantly making decisions on how we architect solutions, and it would be great to have the insight early on that a recent decision might not perform well on a WAN or with larger record sets etc. And every year at DevCon, one speaker or another, will get up there and say that this is faster or better and here is how they tested it.
I submitted this in the product idea section a while back: Comprehensive Solution Profiling
Thanks for reading and please vote on this if you think its important.