FiveTech Software tech support forums

Michel,

it is in Dbinfo.ch.

EMG

This morning,
I tested this through a vpn

The difference in performance is not as clear as yesterday we have 60 seconds versus 75
I use a smaller table.
Yesterday the differenze was 50% faster using that command
This is the source code

Code: Select all  Expand view

#include "dbinfo.ch"
ANNOUNCE RDDSYS


FUNCTION MAIN
LOCAL nInizio  := SECONDS()
LOCAL nContati := 0
LOCAL aArray   := {}
SET EXCLUSIVE OFF

USE n:\hse\la
SET INDEX TO n:\hse\la
dbInfo( DBI_SHARED, .F. )

SET ORDER TO 1
GO TOP
DO WHILE !EOF()        

   AADD( aArray , field->modello )
   SKIP        
   inkey()
ENDDO
? SECONDS() - nInizio            
? LEN( aArray )

INIT PROCEDURE RddInit
REQUEST DBFFPT
REQUEST DBFCDX
rddSetDefault( "DBFCDX" )
RETURN
 

P.S. sometimes my posts do not appear in this group

MarcoBoschi wrote:This morning,
I tested this through a vpn

The difference in performance is not as clear as yesterday we have 60 seconds versus 75
I use a smaller table.
Yesterday the differenze was 50% faster using that command
This is the source code

P.S. sometimes my posts do not appear in this group

For reliable test performance you need to repeat the test a large number of times and then look at average.

I have a huge problem on the network of one of my customers.
It's a Windows 2012 server with 2 virtual servers : a data server and a terminal server.

If a user logs in on the terminal server, everything is running just fine.

But if a user logs in from a workstation (all are Windows 7-64 bits), it's really a disaster. It takes 2 minutes to read 1200 records into an array. That same action takes 3 to 5 seconds on the terminal server.

I added the line "DBINFO (DBI_SHARED,.F.)" but I can't notice any difference.

Keep looking because it is a very big and urgent problem. Thanks.

Michel,

I would check the customer network.

EMG

Enrico,

We tried everything. Enabling and disabling SMB 1.0, 2.0 and 3.0, enabling and disabling oplocks. Nothing seems to be helping.

Michel,

did you check the network speed without programs, using a console COPY command?

EMG

Used commit o dbcommit() ?
I have seen a sharp slowdown

stefano

Enrico,

I tested the network speed without any programs, using the console COPY command. I copied a file of 600 MB from the server to the workstation in just 8 sec. That looks normal to me.


Stefano,

What do you mean? What is the difference betwee commit and dbcommit() ?

Michel,

driessen wrote:Enrico,

I tested the network speed without any programs, using the console COPY command. I copied a file of 600 MB from the server to the workstation in just 8 sec. That looks normal to me.

Yes, it looks like a good speed.

EMG

Michel,

driessen wrote:What do you mean? What is the difference betwee commit and dbcommit() ?

COMMIT is equal to DbCommitAll() that commits all the workareas, while DbCommit() only commits the current workarea. It hardly makes any difference.

EMG

Michel,

Please, issue this commands and reset each PC:

netsh int tcp set heuristics disabled
netsh int tcp set global autotuninglevel=disabled

Lucas,

Thanks a lot but I don't notice any signifant difference.

Have you disabled antivirus?.

I Will do some test later tonight.