Slow RDD experiences
- Enrico Maria Giordano
- Posts: 7355
- Joined: Thu Oct 06, 2005 8:17 pm
- Location: Roma - Italia
- Contact:
- MarcoBoschi
- Posts: 925
- Joined: Thu Nov 17, 2005 11:08 am
- Location: Padova - Italy
- Contact:
Re: Slow RDD experiences
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
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
#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
Marco Boschi
info@marcoboschi.it
info@marcoboschi.it
Re: Slow RDD experiences
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
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.
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.
Regards,
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 21.01 - Harbour 3.2.0 (October 2020) - xHarbour Builder (January 2020) - Bcc7
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 21.01 - Harbour 3.2.0 (October 2020) - xHarbour Builder (January 2020) - Bcc7
- Enrico Maria Giordano
- Posts: 7355
- Joined: Thu Oct 06, 2005 8:17 pm
- Location: Roma - Italia
- Contact:
Re: Slow RDD experiences
Michel,
I would check the customer network.![Smile :-)](./images/smilies/icon_smile.gif)
EMG
I would check the customer network.
![Smile :-)](./images/smilies/icon_smile.gif)
EMG
Re: Slow RDD experiences
Enrico,
We tried everything. Enabling and disabling SMB 1.0, 2.0 and 3.0, enabling and disabling oplocks. Nothing seems to be helping.
We tried everything. Enabling and disabling SMB 1.0, 2.0 and 3.0, enabling and disabling oplocks. Nothing seems to be helping.
Regards,
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 21.01 - Harbour 3.2.0 (October 2020) - xHarbour Builder (January 2020) - Bcc7
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 21.01 - Harbour 3.2.0 (October 2020) - xHarbour Builder (January 2020) - Bcc7
- Enrico Maria Giordano
- Posts: 7355
- Joined: Thu Oct 06, 2005 8:17 pm
- Location: Roma - Italia
- Contact:
Re: Slow RDD experiences
Michel,
did you check the network speed without programs, using a console COPY command?
EMG
did you check the network speed without programs, using a console COPY command?
EMG
Re: Slow RDD experiences
Used commit o dbcommit() ?
I have seen a sharp slowdown
stefano
I have seen a sharp slowdown
stefano
FWH 14.11 + xHarbour + bcc582
Re: Slow RDD experiences
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() ?
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() ?
Regards,
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 21.01 - Harbour 3.2.0 (October 2020) - xHarbour Builder (January 2020) - Bcc7
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 21.01 - Harbour 3.2.0 (October 2020) - xHarbour Builder (January 2020) - Bcc7
- Enrico Maria Giordano
- Posts: 7355
- Joined: Thu Oct 06, 2005 8:17 pm
- Location: Roma - Italia
- Contact:
Re: Slow RDD experiences
Michel,
![Sad :-(](./images/smilies/icon_sad.gif)
EMG
Yes, it looks like a good speed.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.
![Sad :-(](./images/smilies/icon_sad.gif)
EMG
- Enrico Maria Giordano
- Posts: 7355
- Joined: Thu Oct 06, 2005 8:17 pm
- Location: Roma - Italia
- Contact:
Re: Slow RDD experiences
Michel,
EMG
COMMIT is equal to DbCommitAll() that commits all the workareas, while DbCommit() only commits the current workarea. It hardly makes any difference.driessen wrote:What do you mean? What is the difference betwee commit and dbcommit() ?
EMG
- lucasdebeltran
- Posts: 1303
- Joined: Tue Jul 21, 2009 8:12 am
- Contact:
Re: Slow RDD experiences
Michel,
Please, issue this commands and reset each PC:
netsh int tcp set heuristics disabled
netsh int tcp set global autotuninglevel=disabled
Please, issue this commands and reset each PC:
netsh int tcp set heuristics disabled
netsh int tcp set global autotuninglevel=disabled
Muchas gracias. Many thanks.
Un saludo, Best regards,
Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]
Implementando MSVC 2010, FWH64 y ADO.
Abandonando uso xHarbour y SQLRDD.
Un saludo, Best regards,
Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]
Implementando MSVC 2010, FWH64 y ADO.
Abandonando uso xHarbour y SQLRDD.
Re: Slow RDD experiences
Lucas,
Thanks a lot but I don't notice any signifant difference.
Thanks a lot but I don't notice any signifant difference.
Regards,
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 21.01 - Harbour 3.2.0 (October 2020) - xHarbour Builder (January 2020) - Bcc7
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 21.01 - Harbour 3.2.0 (October 2020) - xHarbour Builder (January 2020) - Bcc7
- lucasdebeltran
- Posts: 1303
- Joined: Tue Jul 21, 2009 8:12 am
- Contact:
Re: Slow RDD experiences
Have you disabled antivirus?.
Muchas gracias. Many thanks.
Un saludo, Best regards,
Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]
Implementando MSVC 2010, FWH64 y ADO.
Abandonando uso xHarbour y SQLRDD.
Un saludo, Best regards,
Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]
Implementando MSVC 2010, FWH64 y ADO.
Abandonando uso xHarbour y SQLRDD.
Re: Slow RDD experiences
I Will do some test later tonight.