We tried the anti-virus, web filtering, bad hair day approaches all to no avail... Turned out to be a query that was being ran to generate a list of parts. Ran this way for years but decided to choke on a machine on the network. Move the query before firing the form and all is good. But get this, I could run the old version on my local machine (no network), or from the server and it was fine. We monitored network traffic while the query ran it ramped up to megabytes.....
Appreciate the help, Regards, Desmond
On 1 May 2017 at 16:17, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
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,
- Have you configured the anti-virus and malware scans to EXCLUDE your
application and data folders?
- 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
[excessive quoting removed by server]