Michel,
it is in Dbinfo.ch.
EMG
FiveTech Support Forums
FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour 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
#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" )
RETURNP.S. sometimes my posts do not appear in this group
Marco Boschi
info@marcoboschi.it
info@marcoboschi.it
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.
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. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773
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.
Regards,
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773
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
FWH 14.11 + xHarbour + bcc582
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() ?
Regards,
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773
Michel,
Yes, it looks like a good speed.
EMG
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,
COMMIT is equal to DbCommitAll() that commits all the workareas, while DbCommit() only commits the current workarea. It hardly makes any difference.
EMG
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
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.
Lucas,
Thanks a lot but I don't notice any signifant difference.
Regards,
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773
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.
I Will do some test later tonight.
Regards,
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773