Search the Community
Showing results for tags 'performance'.
The search index is currently processing. Current results may not be complete.
-
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. -
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
-
In my view, in the world of FileMaker Server the concerns of owners and admin with FMS11 and earlier are little different to those of FMS14 admins today. Yes, the product has developed and we now have the new appearance layer from 12 onwards, and WebDirect from 13 on. But, the underlying issue remains, how do you get to understand FileMaker Server and get the best out of it, when it is trivial to build a very "bad" FM solution that is slow and unscaleable and when FMI provides no comprehensive and clear advice? FM software does little to prevent folk using the freedom of FM in that manner, -
Hi My scenario is, when I used to RUN a Import (Folder with Import only the reference) script from a iMac mini to remote Windows File server, it used to take 4-8 hours. But when started using the same script from Same server(Windows), it started to take more than 24 hours. Only things I have changed: Import from Windows FS ( Files of type Windows from OS X) Modified the Folder location to local server. Any suggestions or known issues.. Pls note: Previously we used Filemaker 10-11 now using 13-14 in both client server. The old Mac was OS X (10.5.8) with FM Adv -
I have a vertical market application that uses a php modale that gives mobile users access to their agenda (FM11). Currently I am rewriting this application from fp7 to fmp12. As part of this upgrade I want to offer mobile users an off-line module on iPads. Mainly because mobile users complain that they do not always have a good internet connection when on the road, so the performance is not always acceptable. I have implemented FM EAsySync in my application on a test server and on a small scale this looks good (Tim awesome job in setting up this framework). However, on this forum I noticed
-
Hi there I am experimenting on a sample of data in a very simple FM database. I need some help on 'how' FM does things, rather than how to do something myself (although you may scream at my technique below!) I have two customers on Customer_Table with CustomerID and Name as the fields. The only other table is called Data and is joined to Customer via CustomerID_FK. It's a one to many relationship as each customer can have many data rows, around 400 each. Therefore I have around 800 records in the Data table. I have added three text fields to the data table which enable true/false condi -
Building on the success of classes offered for the first time in Europe last year, an announcement has gone out today about a new series of three-day FileMaker Master Classes offered from March to June 2015 in: • San Francisco (March 2015) • Berlin (April 2015) • London (April 2015 • Westport CT (May 2015) • Sydney (May 2015) • Tokyo (June 2015) The classes are unashamedly targeted at advanced developers, and are packed with high level content ranging from designing for scalability, advanced development techniques, process control, FileMaker application and deployment models, solution des
-
Hi Everyone, I have a database table containing around 700 fileds and half of them are auto enter calculations. Every time i create a new record it takes a long time to create, even more the first time. I just need the record to be created, rest calculations can be done afterwards through scripting. I cannot remove the calculations. Have tried creating the record in seperate table(with the required data only) and then importing those data into my main table, but still, it takes a while. So i was thinking of a way if i can supress the calculations while the new record is created. -
I've been working on optimizing a complex part of a solution that relied on the List() function to send multiple parameters to a custom function. Through my research I came across this article: http://www.teamdf.com/weetbicks/the-search-for-fast-aggregates--trial--error/99/ This article discusses the fact that when you use List(), Sum() or other aggregate functions, FileMaker sends the entire record set to the client, not just the data from the requested field(s). Does anyone know if this is also the case with ExecuteSQL()? I would assume that an SQL query would only return the re -
All, I am building a solution which requires ESS connection to Oracle 11g from FM12. Got the ActualTech Oracle ODBC Oracle Driver. Setup went fine. Managed to do imports from Oracle using the Import Script Step. Can display ESS Shadow tables from Oracle in the FM Relationship graphs. However: * when doing so, FM tells me that the External Table "does not provide a pre-defined unique key" and asks me to choose a field or field combination to identify the same * All relationships i perform involving an ESS table display the 'T' cardinality symbol implying that the match field has
