General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Multi-users drops speed by 80%?
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
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