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
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
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
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]
Desmond Lloyd wrote on 2017-05-02:
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
Desmond,
Did the query change? Did the indexes on the table change?
It could be the index or table has just gotten large enough that the network has reached its limit for sending it down as a single process.
We've seen that here when multiple workstations access the same table. Christof explained it well once. https://leafe.com/archives/msg/497230
Tracy Pearson PowerChurch Software
Hard disk(s) turned off due to power-saving?
On Mon, May 1, 2017 at 10:17 PM, Desmond Lloyd desmond.lloyd@gmail.com wrote:
Now there is a long pause before the screen is displayed to add these transactions, and a lag when saving a record....
-
Desmond Lloyd -
Man-wai Chang -
mbsoftwaresolutions＠mbsoftwaresolutions.com -
Tracy Pearson