2 posts in this topic
Slow layouts become faster after changing Auto-Enter calculation
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 empty, but will be either 0 or 1. Users have lately been complaining that toggling this checkbox is becoming incredibly slow. I initially tried to remove objects from the Checkin Layout, but found that even if the layout contained nothing but the field in question, toggling the checkbox was still incredibly slow. I then tried changing the auto-enter calculation, thinking that may help. I changed the "Case" function to "If" and noticed that the speed shot up immediately. However, I found that if i closed and reopened my layout, the slowness came back. After some more experimentation, I found that opening the "Manage -> Database" window and changing ANY definitions or calculations would make the Checkin Layout extremely fast, until it is closed. Then once it is opened it becomes slow again.
I'm curious if there is anything happening when I adjust definitions that I could do via scripting. The slowness is taking its toll on productivity, and I can't be around to mess with definitions every time a user needs to check something in. Is there anything I can do??
Thanks in advance for your help.
Thoughts of this new "Top call statistics" logging feature
I'm considering upgrading my FM servers to v15, mostly for the Top Call Statistics, but also the WebDirect features. To save me some time and effort, has anyone used the Top Call Statistics in a meaningly way and can give a honest review of it? Is it really helpful in any way, and if so, how? Or is it another feature that looks great on the onset, but not very helpful once you start using it?
FM15 Server, Virtual Hosts, 1 Box
Every time I upgrade FM I lose functionality. This time, it seems that FM15 Server does not play nice with OS X Server 5. I have the latest versions of each. OS X is finding my virtual hosts just fine but installing FM15 Server breaks that. All virtual hosts display the FILEMAKER DATABASE splash screen.
I read a long post about this problem relating to 13/15. Any new insights or workarounds for 15?