Search the Community
Showing results for tags 'performance'.
-
Custom Function Optimized to Evaluate Hundreds Times Faster
HOnza posted a blog entry in HOnza's Bits @ FMForums
Two weeks ago I wrote an article about a FileMaker custom function I needed to preprocess some data imported from the web. I used this custom function in an auto-enter calculation to immediately preprocess the data while being imported. I created a server-side script that does the import every morning. But when I discovered that the import was taking over an hour every day, I saw it deserves some optimization. I used FM Bench Detective and optimized the custom function to evaluate up to several hundreds times faster… Read the whole article... -
I noticed that one of the articles updated in the official FileMaker Knowledge Base on September 23, 2011 was explaining how to select a random set of records in a FileMaker database. I was wondering how fast the currently recommended technique is and whether Ican make it faster with the help of FM Bench. I tried to apply it to a set of 50,000 records of randomly generated data. Then I made it much faster… Read more in the original article
-
This example demonstrates that even a single-step script can be optimized. You just have to think a little bit out of the box… I was showing this as a surprise in my session Marvelous Optimizations at Pause On Error [x] London 2011. I used a sample file with 25 fields and 5,000 records and imported these records 5 times in a row in just 13 seconds. OK, 13 seconds is not bad but what if you need to import data into FileMaker Go over network? If you want to know how I imported the same data in less than 3 seconds, watch the following video from my Pause On Error session. Read more
-
Last September I wrote an article about a custom function that I optimized to evaluate hundreds times faster. At the end of the article, I challenged my readers and myself by claiming that the already optimized custom function can be optimized even further. Do you remember? Later on I actually really optimized it again, and talked about this optimization during my session at Pause On Error [x] London 2011. Now you can watch the video of this part of my session below: Read more and download my updated sample file at honza.24uSoftware.com.
-
We have tested all our products and are happy to confirm that they all work fine with the new version, only iOS versions of our plug-ins need to be updated for the new iOS App SDK. Now we are preparing our performance lab to test FileMaker 19 performance and compare it to the previous versions. Read more details in our latest article and let us know what you would like us to include in our performance test. The article also explains what we consider being the three most valuable new features of FileMaker 19 and why.
-
On January 19, 2021 we met online for the second time to discuss my FileMaker performance lab testing results. For the case you either missed the meeting, or attended and want to recall some details, a recording of the meeting is now available... In the meeting I talked about the impact of record size on performance being often higher than impact of any other factor. As a surprise I also showed my first results of testing actual simultaneous clients connecting to FileMaker Server 19.2 instead of simulating clients by server-side scripts. At the time of the meeting, however, I w
-
Development Scheduling Optimized with Web Viewer
HOnza posted a blog entry in HOnza's Bits @ FMForums
We use our own app called Collector to manage our software development projects. A few years ago my colleague Milan started feeling the need to schedule our development capacity more precisely. So we created a detailed plan layout. In the following video you can see what the layout looked like and how we later optimized it using Web Viewer and JavaScript. In the first version of the layout, we used a list view with 31 filtered portals in the body part and another 31 portals in the footer to show summaries. That required FileMaker Pro to render 11 625 fields just for th -
It has never been easier to find your way among FileMaker license or to deploy a server in the cloud. fmcloud.fm is a unique hosting service, based on a docker/Linux architecture. According to @Nick Lightbody's benchmark on Medium, our architecture is 4 times faster (yes, 400%!) than a standard Windows/VPS service. And… we've got a free trial! Your databases could literally be in the cloud in 5 minutes from the moment you click this link. -
My new piece on Medium - with an in depth performance analysis between different types of deployment for FileMaker Server. Deployment in a Docker Container on a powerful cloud server comes out as a standout option. It will be fascinating to hear your own experience - does it differ from what my testing reveals? It will also be fascinating to hear from Wim how the results he gets from his new Punisher performance tool compare with what we get with dsBenchmark? Cheers, Nick https://nicklightbody.medium.com/claris-filemaker-server-19-a-performance-test-of-linux-v-windo -
When most of the world is forced to work from home, many things you took for granted can disappear over night. Speed of the internet is one of them, performance of your business critical apps follows very closely. The good news is that most of the custom FileMaker apps out there do not use the full power of the platform and they can be made much faster. So let me share a few tips on how you can optimize your FileMaker apps for working from home over the slower-than-usually internet connection. Do you know what tools you can use and how you can improve your app's performance to an ac
-
Excerpts from my “FileMaker 17 Performance Lab” session are available, covering some of the topics not covered anywhere else, as well as from my presentation of upgraded demo integrating 11 hardware technologies. Take a look at highlights of the FileMaker Konferenz 2018 and learn how field dependencies can slow down your Set Field, how to minimize the impact of slow network connection, why to avoid overusing conditional formatting, how to benchmark and optimize layout rendering, or how to integrate RFID, NFC, mobile printer, motors, digital scale, and other hardware with FileMaker app running
-
Demystifying the FileMaker Server Top Call Stats Log Are you wondering why your FileMaker Server is running slowly or performing poorly? The FileMaker Server top call statistics log can help. It records up to 25 of the most impactful remote calls to your server that occur during a collection interval. Using this native FileMaker feature, you can see who is connected to your server and what actions they are performing. This can give you an idea of why your server might be running slowly or performing poorly. Sometimes it can be difficult to understand all of the statis -
In October 2017 I presented two sessions at the German-speaking FileMaker Konferenz. My first session was focused on results of almost forty thousand performance tests our team had performed and evaluated to compare different versions of FileMaker Pro and FileMaker Server and the second one was focused on our recent great discovery of the impact of database structure on its performance. Now we have made the best parts of those sessions publicly available, so don’t hesitate and dive into the deep waters of FileMaker performance and I hope you'll find the videos useful.
-
Testing FileMaker Network Performance Part 1 Get up to speed with the FileMaker Video Training Course! FileMaker is a cross-platform relational database application from FileMaker Inc. https://en.wikipedia.org/wiki/FileMaker Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro17.php Customer relationship management, processes implemented to manage a company's interactions with customers and prospects https://en.wikipedia.org/wiki/CRM Experience Richard's dynamic and exciting teaching format, while learning both basic, interme -
FileMaker Coaches' Corner - Tip 11 - Improve Performance - FileMaker - FileMaker Experts https://youtu.be/5D2qoA_S7u8 Get up to speed with the FileMaker Pro 17 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 27 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference ,Richard will teach you all the ins and outs of buildin
-
So I have a hosted solution, with a dashboard with a couple portals. When I go to scroll a portal, scrolling even one portal screen has a delay of a few seconds, ie I click the scroll bar or try to drag it, and it takes about 3 seconds before it moves. Running locally, it's instantaneous. Running on a dev server on my LAN, there's a slight delay, but minimal. Having read various threads about this situation, my first thought was it's due to a filtered portal, so I removed filtering, but that made no difference. I also read various posts about unstored calcs and other factors that wou
-
Environment: FMS 15 Windows Server 2012 host on Azure Plug in: 360Works ScriptMaster Purpose for using the Plug in: zip the pdf files. Problems We have: There are a large amount temp files created on the client machine which run the fmp to connect the server , the temp files won't removed. What I am looking for: Any script step can avoid these temp files stay in temp folder. How these files created? I attached a screenshot. Thanks
-
Hey again. In a previous thread I suggested using javascript in a webviewer to return the difference between the server and client UUID lists in order to increase the sync check speed. It was much faster, but the code I used included an algorithm with quadratic time complexity, meaning that as the size of the lists increased the time that sync check took would grow exponentially. @GisMo helped test confirm that this solution would not scale well. However I think I've found a bit of javascript that solves this issue and will scale linearly. I've changed the script from the previous thread- 24 replies
-
- 2
-
-
- sync check
- fmeasysync
- (and 3 more)
-
Let’s say we have two related tables: “Invoice” and “Invoice_Item”. We could create a calculation field in the “Invoice” table called “total_amount” with this formula: total_amount = Sum (Invoice_Item::amount) This field would have a negative impact in performance when appearing in the layout, since it would have to be defined as unstored, because it’s referencing a field from a related table. Now let’s suppose this field is not used for any scripts, tooltips, conditional format, etc … would the performance of the database be negatively affected ONLY when this field appeared in -
Is there any difference in terms of performance between a calculation field (stored and indexed) and field defined as auto-enter calculated value (indexed)? For example, we have an “INVOICE” table, with a field called “date_invoice_sent”, and we’d like to have a boolean field called “is_sent”. The calculation would be “not IsEmpty(date_invoice_sent)” So we have two options here: - Calculation field (stored, number result). - Number field defined as “auto-enter / calculated value / do not replace … unchecked”. Would there be any difference in performance between the t
-
I have a system being hosted using FMS14. I also have a duplicate database hosted for testing/exporting using FMS15. PSOS is much slower in my hands with FMS15. Both servers are physical boxes, with similar (maybe identical) specs (Cores, RAM HD Space, HD Space available) I also have a Server Side script that creates a found set, exports data to excel and emails it to a user. (This is based on https://www.skeletonkey.com/restoring-filemaker-clients-found-set-within-server-side-script/). The exports have a couple of related fields, but no unstirred calculations. Using FMS14 th
-
Performance of using UUID as a primary key
VictorLion posted a topic in Interface Design Discussions
I am building a customer database. The database will have a primary key. I am looking to make the primary key either a unique integer or a UUID (with 32 chars). The UUID appeals to me due to its ability to sync tables. The primary key will be used for (obviously): Searching and sorting records As a tag against documents eg document XX is linked to customer AA, BB and CC; and A foreign key to link tables My questions are: Do UUIDs adversely affect database size Do UUIDs adversely affect speed If UUIDs retain their full 32 chars, then there will obvious -
Hi everyone, currently I am looking into creating a very simple database for a cocktail competition for a spirits brand. The competitors are coming from markets all over the worlds, the local offices are submitting the recipies, images and some further information in my ideal world via webdirect into the database itself. I dont think there need to be more then 2-3 users accessing that database simultaneously. My question would be if anyone is experienced with filemaker hosters and the perfomance of that hosting when the db is accessed from different parts of the world. -
Hi all My server is running on FMS 13.0v9 and my clients are running FMP 12.0v4. The mismatch is due to my clients still mostly being on OS X 10.6.8. I'm having a strange issue with slowness that I was hoping to get some insight on. Here goes: I have a layout (named "Checkin Layout") that access a table and a few related tables. The main table has a field named "CheckedIn" which contains either a 1 or a 0. The user checks a checkbox, which enters the value "1". The auto-enter calculation is as follows: Case (CheckedIn = 1 ; 1 ; 0) This makes it so that the value isn't ever -
Hey Fellow Easy Sync-ers. I have an idea for improving the speed of the Sync Check step. Instead of comparing UUID lists in loops, we can retrieve a UUID list from server, and compare it to the client UUIDs using a couple lines of JavaScript in a webviewer. I've tested this and my Sync check time comparing ~23000 records, over 18 sync tables on a shared server has gone from 5-10 minutes down to a few seconds. No plugins necessary. Process: Get UUIDs_client. Get full UUIDs_host list from server Format both as JavaScript arrays and put them into a web viewer to be co
