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
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
