Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-users drops speed by 80%?
Message
From
30/04/2002 09:02:56
 
 
To
30/04/2002 08:51:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00650803
Message ID:
00650805
Views:
28
One frequent cause for slowdowns like this is anti-virus software.

If there is some running, see if the responsible folks will revise it to not touch VFP-related file types. Or maybe even turn it off temporarily, just to prove (or not) the case.

good luck


>I have a weird one that I cant figure out, maybe someone can help or point me in the right direction ;)
>
>I wrote a system for a client which has a module for inventory management, when they do transactions with a single user online the system works fine and saving a transaction will be almost instataneous. But when they have more than one user online saving a transaction starts taking up to 20-30 seconds which is really weird. The code for the transaction saving has at most 3-4 SEEKs, maybe a couple of APPEND/REPLACE (depending on situation) and 1 GATHER NAME. This shouldnt take 20-30 secs for sure.
>
>Before I start the shouting match with their network people, I want to make sure I investigate this fully on my side.
>
>Each form has its own private data session, no buffering, and I do the LOCK/APPEND/UNLOCK the old fashion way.
>
>The data session of each form calls a method of the application that executes the following code in BeforeOpenTables:
>
>SET BELL OFF
>SET CPDIALOG OFF
>SET DELETED ON
>SET ESCAPE OFF
>SET EXACT ON
>SET EXCLUSIVE OFF
>SET MESSAGE TO
>SET MULTILOCKS ON
>SET NEAR OFF
>SET NOTIFY OFF
>SET SAFETY OFF
>SET SYSFORMATS OFF
>SET ECHO OFF
>SET TALK OFF
>SET STATUS OFF
>SET STATUS BAR OFF
>
>Any suggestions about what could be causing the slow-down?
>
>Thanks in advance
>
>Pascal
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform