On 2017-05-01 10:17, Desmond Lloyd wrote:
Good Morning,
Have an application that has been running for years, we add transactions via one form that displays the transactions in a grid. When adding we pop a form, when saving I do the old append blank gather memvar thing. Has worked well until recently...
Now there is a long pause before the screen is displayed to add these transactions, and a lag when saving a record....
The odd thing is that running it from the server it runs fine. If I run from my local machine it is fine. Even copied it out to another network and it was fine as well...
Nothing unusual in getting the form ready to display. As mentioned just a quick append blank gather memvar on the add....
Network response from other applications is fine....
Any thoughts? TIA, Desmond
Hi Desmond,
1) Have you configured the anti-virus and malware scans to EXCLUDE your application and data folders?
2) INSERT INTO (FieldName) FROM NAME thisform.oRecord is better than APPEND BLANK and GATHER MEMVAR because the former updates the indexes ONCE whereas the latter updates them TWICE.
hth, --Mike