VFP speed issues in multi user environment

[cliffhead]

All

Wondering whether anyone can help.

We have an application that is heavily used in a multiuser environment. Over the last 18 months or so, we have had a large number of performance related issues in the product but only when operating in a multi user environment.

For example, if one user is has changed the data in one particular table and another, or multiple users try a process that accesses that table, the user can experience a significant time delay.

It only appears to be an issue with Server 2008 and Windows 7 onwards. We have reviewed SMB versions, Anti Virus, different network card settings which we have seen a slight increase in some cases but not acceptable.

Are there issues with VFP running with SMB in a multi user environment which may cause performance issues. The code in these areas has not changed for years but more recently has become a problem.

Can anyone help....is there a environment related solution out there

 

[Mike Lewis]

Is this the same problem you reported a few weeks ago (thread184-1697874)? Olaf suggested that it might be caused by oplocks. Did you ever follow that up.

There was also a more recent thread that might be relevant: thread184-1699111

And so might this article: Trouble-shooting a Visual FoxPro application

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[IlyaRabyy]

In addition o the Mike Lewis' inquiry:
What version of VFP this software was written in? (You've said "code in these areas has not changed for years ", so it might be 10 years, and even 15 years back in VFP3 or VFP5 ;-) )

Regards,

Ilya

 

[SBTBILL]

If you used manual locks as SBT does then you could have a locking problem. This might be due to bad code.