Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Lag on Windows 10
Message
From
12/12/2016 15:36:54
 
 
To
12/12/2016 12:51:12
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2012
Database:
Visual FoxPro
Application:
Desktop
Virtual environment:
VMWare
Miscellaneous
Thread ID:
01644926
Message ID:
01644938
Views:
63
>Hi all,
>
>Wondering if anyone can either confirm this problem and/or suggest a fix (even confirming it would be nice):
>
>- desktop app, mostly free tables
>- uses and posts from local views
>
>Problem: users enter a quote in a form where this is the parent record and child records (same form); under Windows 10, when users save out the data, if they go back into the form, the child records do not show up right away. This only happens under Win10. Here is what I know and have tested:
>
>- suggested technique for the framework I am using is to issue a quick RLOCK() on the affected tables this is supposed to force VFP to re-read the tables (in their notes, this is the fix if a user cannot see data posted by another user on the network - but the problem is that the user cannot see the data they themselves have just posted)
>
>- I have turned off a feature in the app which upon app startup, opens tables in the default data session of the app *and keeps them open* - this feature is in the app to speed up subsequent openings. I have turned this off so that hopefully, when the user re-opens the form they have worked on, it forces VFP to re-read the table.
>
>Anyone else seen this behaviour?

If you're not doing it already, it's a good idea to apply the registry changes outlined at http://www.alaska-software.com/community/smb2.cxp to every workstation that accesses VFP data tables.

I see you list "VMWare" in "Virtual environment" in the message header. Is the server storing the VFP data tables virtualized, clustered or anything else unusual? Is it a true Windows server, a NAS, or ?

Are the Windows computers running your app actual physical computers, sessions on a Remote Desktop or other VDI backend, or anything else?

You've also titled this thread "Data Lag". What does that mean - does freshly input data eventually show up after some period of time, or does it never show up unless you perform drastic actions to force a re-read of the data?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform