Slow RDD experiences

[Enrico Maria Giordano]

Michel,

it is in Dbinfo.ch.

EMG

[MarcoBoschi]

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

[Patrizio]

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.

[driessen]

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.

[Enrico Maria Giordano]

Michel,

I would check the customer network.

EMG

[driessen]

Enrico,

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

[Enrico Maria Giordano]

Michel,

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

EMG

[stefano]

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

stefano

[driessen]

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() ?

[Enrico Maria Giordano]

Michel,

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

[Enrico Maria Giordano]

Michel,

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

[lucasdebeltran]

Michel,

Please, issue this commands and reset each PC:

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

[driessen]

Lucas,

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

[lucasdebeltran]

Have you disabled antivirus?.

[driessen]

I Will do some test later tonight.