>Hi Tore...
>
>When I say hang its more like verrrrry slow filtering the data and populating the grid. For example if I have a table with 50,000 customer names issuing the command
>
>Set filter to "MARY MURPHY" $ uppe(name)
>
>can take minutes rather than seconds. It does eventually get there but the client justifiably does not want to wait. It is only a problem using Win7 and especially Win8 PCs when connected to a server containing the tables. In stand-alone Win7 it does not seem to be an issue. Although having said this, I do have clients using Win7 and there does not seem to be an issue... Or maybe they are putting up with the wait.. :)
>
>In any case I feel I need to move up a platform and am wondering if Lianja is the way to go. I am hoping I can take my existing projects and just import, recompile and run. Am I expecting too much here?

One possibility you can check fairly quickly is antivirus. If AV real-time scanners (on workstations and/or the server computer) are actively scanning VFP tables it can slow access to them a lot. You can test for this by temporarily disabling real-time scanning on all workstations (and the server) that may be simultaneously accessing the tables. Or, exclude the files or folders containing the data tables from real-time scanning.

Windows Vista and later introduced new complications in networking. It's more difficult to get networking set up exactly right. And if it isn't, a networked VFP app will have performance problems. You may need to do things like make sure DNS is configured correctly, disable IPv6 if it isn't being used etc. There are lots of network settings that have to be right, a comprehensive list is beyond the scope of this forum - talk to your network admins.

As an aside, when networking VFP tables on Vista/Windows Server 2008 or later, beware the SMB2 bug: http://www.alaska-software.com/fixes/smb2/overview.shtm