Page 3 of 4
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 8:15 am
by Enrico Maria Giordano
Michel,
it is in Dbinfo.ch.
EMG
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 8:49 am
by 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
#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
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 9:02 am
by Patrizio
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.
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 9:03 am
by 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.
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 9:16 am
by Enrico Maria Giordano
Michel,
I would check the customer network.
EMG
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 9:26 am
by 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.
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 9:30 am
by Enrico Maria Giordano
Michel,
did you check the network speed without programs, using a console COPY command?
EMG
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 9:55 am
by stefano
Used commit o dbcommit() ?
I have seen a sharp slowdown
stefano
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 10:10 am
by 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() ?
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 10:19 am
by Enrico Maria Giordano
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
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 10:24 am
by Enrico Maria Giordano
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
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 12:14 pm
by lucasdebeltran
Michel,
Please, issue this commands and reset each PC:
netsh int tcp set heuristics disabled
netsh int tcp set global autotuninglevel=disabled
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 12:51 pm
by driessen
Lucas,
Thanks a lot but I don't notice any signifant difference.
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 2:16 pm
by lucasdebeltran
Have you disabled antivirus?.
Re: Slow RDD experiences
Posted: Wed Jun 04, 2014 4:14 pm
by driessen
I Will do some test later tonight.