Slowdown performance with concurrent access

Slowdown performance with concurrent access

Postby rcastano » Wed May 06, 2009 11:39 pm

Greetings:

I have an accounting software running over CENTos-RH + Samba with Windows XP clients. When the four (4) application users get access simultaneosly, the performance of the application slowdown and the access to data tables (DBF) using CDX index files goes really slow. Any sugestion in the reason of this big trouble. Thanks in advance for the help that you can give me about that.

Regads

Ricardo Castano Abufhele
Ricardo Castano Abufhele
(fwh 11.04 Apr 2011, xHarbour, bcc 5.82, win7pro)
rcastano1@gmail.com
Bogota - Colombia
rcastano
 
Posts: 30
Joined: Sun Oct 01, 2006 6:20 pm

Re: Slowdown performance with concurrent access

Postby rcastano » Wed May 06, 2009 11:46 pm

I'm using FWH 8.04 April 2008...
Ricardo Castano Abufhele
(fwh 11.04 Apr 2011, xHarbour, bcc 5.82, win7pro)
rcastano1@gmail.com
Bogota - Colombia
rcastano
 
Posts: 30
Joined: Sun Oct 01, 2006 6:20 pm

Re: Slowdown performance with concurrent access

Postby driessen » Thu May 07, 2009 11:21 am

Maybe an update of FWH and Harbour of xHarbour would solve your problem. If an update does not solve your problem, the cause must be found somewhere else.

I have some customers where more than 30 users are using my application simultaniously (with more than 5 GB of data) and the performance is just perfect for all of them.

Good luck.
Regards,

Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 24.02 - Harbour 3.2.0 (February 2024) - xHarbour Builder (January 2020) - Bcc77
User avatar
driessen
 
Posts: 1399
Joined: Mon Oct 10, 2005 11:26 am
Location: Genk, Belgium

Re: Slowdown performance with concurrent access

Postby Carlos Mora » Thu May 07, 2009 1:18 pm

Ricardo,

you should provide more information to try an answer. I've been using samba for years with excelent results. ¿Wich compiler/rdd are you using?
How is you Oplocks configuration in both XP clients and Samba?

Regards
Saludos
Carlos Mora
http://harbouradvisor.blogspot.com/
StackOverflow http://stackoverflow.com/users/549761/carlos-mora
“If you think education is expensive, try ignorance"
Carlos Mora
 
Posts: 988
Joined: Thu Nov 24, 2005 3:01 pm
Location: Madrid, España

Re: Slowdown performance with concurrent access

Postby James Bott » Fri May 08, 2009 12:49 am

Ricardo,

Maybe you should create a really simple test program to test the concurrent access speed. This way you can find out if the problem is something in your main application, or OS/network/FW.

Regards,
James
User avatar
James Bott
 
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA

Re: Slowdown performance with concurrent access

Postby rcastano » Fri May 15, 2009 1:18 pm

Finally, the trouble was found in the samba configuration with the oplocks seted in the smb.conf. It seems that using DBF/CDX files with concurrent access over a Samba system don't work as fine as I would hope. Thanks a lot for the answers to the forum.
Ricardo Castano Abufhele
(fwh 11.04 Apr 2011, xHarbour, bcc 5.82, win7pro)
rcastano1@gmail.com
Bogota - Colombia
rcastano
 
Posts: 30
Joined: Sun Oct 01, 2006 6:20 pm

Re: Slowdown performance with concurrent access

Postby Carlos Mora » Sun May 17, 2009 10:38 am

rcastano wrote:Finally, the trouble was found in the samba configuration with the oplocks seted in the smb.conf. It seems that using DBF/CDX files with concurrent access over a Samba system don't work as fine as I would hope. Thanks a lot for the answers to the forum.

Saying that sounds a little bit unfair. Samba works perfectly with all versions of RDDs, I've been using it for years with Clipper and Harbour. If the default configuration for Samba is to act like a NT Server with a low order System Level, it shows to the workgroup like and old NT Server, causing XP and newer MS OS takes an aggresive way to open files. This behavoir can be changed in XP registry, or disable the OPLOCKS options in Samba. This is a very common matter and very welll documented.
I should recommend to take a look into the ebox project, that looks very promising and is a serious and very complete server for several tasks, fully documented and supported from several organizations, including the spanish goverment.

http://ebox-platform.com/

Regards
Saludos
Carlos Mora
http://harbouradvisor.blogspot.com/
StackOverflow http://stackoverflow.com/users/549761/carlos-mora
“If you think education is expensive, try ignorance"
Carlos Mora
 
Posts: 988
Joined: Thu Nov 24, 2005 3:01 pm
Location: Madrid, España


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 127 guests