General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only