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 would cause all the data to have to be transferred to the client over the WAN.
But here's the thing - at the moment, there are about 20 records in the database, related to the particular portal.
Clearly, moving that data can't be the primary issue - right?
I do have a lot of Execute SQL calculations in related tables, and I've read that can cause poor performance. But wouldn't that only be a factor when there are a lot of records?
Are there design /schema choices that would cause significant lag regardless of the amount of data?
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.
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 a layout?
In other words, would adding an unstored calculation field to a table involve a performance penalty, even in the “unreal” case where this field didn’t appear in any layout, script, conditional format, etc.? thanks in advance!
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 two options? thanks in advance!
I had been using FM EasySync for few months now, so it had been working fine till now.
Without having any change in the table structure, i got the error " The attempt to push data into server has failed ( The mesage recevied rom the server was "852" )
852 Error is : Cannot write a file to the external storage
I believe this is related to container fileds I am using. There has been no change in the Container field options. They are still being stored "Externally" on the server with Open Storage option. Also there hasn't been any change on Server policies as well.
I have no clue as to what could have cause this. Anyone having idea about this ??