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, <mbsoftwaresoluti...@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, > > 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 > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/caajxvaneq2ub1souxpnval0z2sod62nmsyjhtxqvcfdx+vd...@mail.gmail.com ** 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.
