Software Runs Slow in Network PC

[Swaroop Joshi]

After successfully running my Clipper Software in Windows-10 64 bit with the help of Harbour

I am facing a problem that some of the Reports in Software where there is enough processing runs very slow in Network Computer (Client PC)

The same Reports takes only 10 seconds in Server PC where the Software is installed 

Whereas in Client PC it Takes 6 Minutes to Display the same Report after process.

This Problem Occurs in Clients PC when the same Software too is running in Server PC.

When The Software is not running in Server at that time the Reports takes only 12 Seconds in Client PC

Please Suggest me the solution.

Thanks in Advance

Swaroop S. Joshi

[Gerald Drouillard]

Are you running with the databases open exclusively?

If not, do you have a shared index file active while skipping through the database?  You will probably notice other clients slowing down when this report is running.

[Angel Pais]

Hi Swaroop

So next step would be to add RDDLETO to your software !

El mié., 8 may. 2019 a las 17:27, Gerald Drouillard (<ger...@drouillard.ca>) escribió:

Are you running with the databases open exclusively?

If not, do you have a shared index file active while skipping through the database?  You will probably notice other clients slowing down when this report is running.

--
--
You received this message because you are subscribed to the Google
Groups "Harbour Users" group.
Unsubscribe: harbour-user...@googlegroups.com
Web: http://groups.google.com/group/harbour-users

---
You received this message because you are subscribed to the Google Groups "Harbour Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to harbour-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/harbour-users/CAC_Y%2BMBqdLa7JpwHEMPfh6sEAdHY0DcPd00q_0sbcL4T%2BPW%2Bgg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[Nenad Batocanin]

Check these (I suppose the code is optimized enough):

 

- Does the AV software od server and clients scan DBF tables and indexes? If yes, make exceptions.

 

- Is DEP enabled for all files on the server? He can slow down a lot.

 

Permanent solution is to use Letodb or Letodbf.

 

Regards, Nenad

--

--
You received this message because you are subscribed to the Google
Groups "Harbour Users" group.
Unsubscribe: harbour-user...@googlegroups.com
Web: http://groups.google.com/group/harbour-users

---
You received this message because you are subscribed to the Google Groups "Harbour Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to harbour-user...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/harbour-users/44443c85-496c-4927-b560-17fe81c9c9b5%40googlegroups.com.

[Francesco Perillo]

I think to know what is happening....

You didn't disable the oplocks...

A. When you run the report in local, 10 seconds...

B. When you run the report from the lan and you are the only user opening the files, 12 seconds

C. When you run the report from the lan and you are NOT the only user opening the files, 360 seconds...

In case B, the SMB server, knowing only 1 client is using the file, permits client-side caching, simulating a exclusive use. But in case C it can't and every time the client skip to a new record, it must request the data from the server, since another client may have modified it.

If you disable oplocks or force use of SMB1 case B and C will both last 360 seconds....

Of course, I haven't seen the code.... so this is from my experience...

Francesco

--

[Swaroop Joshi]

My Problem in the C case when both the users are working simultaneously. suppose in server the user is in Data Entry menu which has little process

and in Client PC generating Reports which have much more processing.

I open Database in Shared mode in both Data Entry and Reports  e.g.

Use Workdet Index Workdet share new

Use Cont Index Cont share new

i m just Retrieving Data from this 2 Files without doing any changes and copy to another Temp.Dbf which is not shared and generate report

On Thursday, May 9, 2019 at 1:39:10 PM UTC+5:30, fperillo wrote:

I think to know what is happening....

You didn't disable the oplocks...

A. When you run the report in local, 10 seconds...

B. When you run the report from the lan and you are the only user opening the files, 12 seconds

C. When you run the report from the lan and you are NOT the only user opening the files, 360 seconds...

In case B, the SMB server, knowing only 1 client is using the file, permits client-side caching, simulating a exclusive use. But in case C it can't and every time the client skip to a new record, it must request the data from the server, since another client may have modified it.

If you disable oplocks or force use of SMB1 case B and C will both last 360 seconds....

Of course, I haven't seen the code.... so this is from my experience...

Francesco

On Wed, May 8, 2019 at 9:28 PM Swaroop Joshi <swaroop...@gmail.com> wrote:

After successfully running my Clipper Software in Windows-10 64 bit with the help of Harbour

I am facing a problem that some of the Reports in Software where there is enough processing runs very slow in Network Computer (Client PC)

The same Reports takes only 10 seconds in Server PC where the Software is installed 

Whereas in Client PC it Takes 6 Minutes to Display the same Report after process.

This Problem Occurs in Clients PC when the same Software too is running in Server PC.

When The Software is not running in Server at that time the Reports takes only 12 Seconds in Client PC

Please Suggest me the solution.

Thanks in Advance

Swaroop S. Joshi

--
--
You received this message because you are subscribed to the Google
Groups "Harbour Users" group.

Unsubscribe: harbou...@googlegroups.com

Web: http://groups.google.com/group/harbour-users

---
You received this message because you are subscribed to the Google Groups "Harbour Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to harbou...@googlegroups.com.

[Swaroop Joshi]

can u share me a example of LETDB or LETODBF as i have never used this concept.

On Thursday, May 9, 2019 at 5:44:18 AM UTC+5:30, Nenad Batoćanin wrote:

Check these (I suppose the code is optimized enough):

 

- Does the AV software od server and clients scan DBF tables and indexes? If yes, make exceptions.

 

- Is DEP enabled for all files on the server? He can slow down a lot.

 

Permanent solution is to use Letodb or Letodbf.

 

Regards, Nenad

 

From: harbou...@googlegroups.com <harbou...@googlegroups.com> On Behalf Of Swaroop Joshi
Sent: Wednesday, May 08, 2019 9:28 PM
To: Harbour Users <harbou...@googlegroups.com>
Subject: [harbour-users] Software Runs Slow in Network PC

 

After successfully running my Clipper Software in Windows-10 64 bit with the help of Harbour

 

I am facing a problem that some of the Reports in Software where there is enough processing runs very slow in Network Computer (Client PC)

 

The same Reports takes only 10 seconds in Server PC where the Software is installed 

 

Whereas in Client PC it Takes 6 Minutes to Display the same Report after process.

 

This Problem Occurs in Clients PC when the same Software too is running in Server PC.

 

When The Software is not running in Server at that time the Reports takes only 12 Seconds in Client PC

 

 

Please Suggest me the solution.

 

 

Thanks in Advance

 

 

 

Swaroop S. Joshi

--
--
You received this message because you are subscribed to the Google
Groups "Harbour Users" group.

Unsubscribe: harbou...@googlegroups.com

Web: http://groups.google.com/group/harbour-users

---
You received this message because you are subscribed to the Google Groups "Harbour Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to harbou...@googlegroups.com.

[Koshal Agarwal]

try indexing at local level instead of using index on server

[Andreja]

Does anyone have step by step settings for registry or something like Nick Ramsay registry fix for Windows 10?OR the same fix can be used on Windows 10?

I also found somewhere that if you want to share dbfs over LAN in Windows 10 you have to turn off SMB2 which will activate SMB1 protocol and then you need to disable oplocks.

If  anyone allready did this it would be nice to see procedure used for Harbour apps.

Also when using win_osnetregok function do you compile this function  which you run once or you implement the function in your app code so it runs every time you start your app?

[Nenad Batoćanin]

After the initial setup, the use is very simple. You just need to change the USE commands to something like this:

RddSetdefault( "LETO" ) 

cPath := "//192.168.0.1:2801/data/"

...

USE (cPath + "Test") NEW

The best thing: all the commands in the program (REPLACE, FILTER, SEEK, GO, alias...) remain unchanged. It is necessary to include LetoDB libraries into your exe, and start LetoDB service on the server that actually executes commands. More detailed instruction:

https://www.kresin.ru/en/letodb.html

On this list you can find information about LetoDBF fork that also works great.

Regards, Nenad

[Yugo Turbo]

Hello,

You can run this software with Novell NetWare Networks or OES.


Best Regards

[Maurício Faria]

Hi.
 
I was presented to this issue recently and it was somewhat hard to find an acceptable solution.
 
Microsoft does not support SMBv1 anymore and seems oplocks went away with it.
But MANY legacy systems needs it and probably some big players pressured Microsoft for an acceptable solution.
And there is a "hidden" configuration to disable oplocks on SMBv2 and greater.
See this https://twitter.com/nerdpyle/status/876880786418352128 and https://www.mowasay.com/2018/08/windows-10-2016-build-1709-1803-cannot-connect-to-smb-shares/
 
You have to configure it via Powershell command Set-SmbShare using the LeasingMode None parameter.
 
Note that this is NOT documented by Microsoft !!!  See https://docs.microsoft.com/en-us/powershell/module/smbshare/set-smbshare?view=win10-ps

If you search Google for "Set-SmbShare" "LeasingMode" you will see how this is "hidden"...

 
One interesting thing is that this is a per share configuration, so you can use it only in the share you use the Harbour application and the other ones will not be affected.
 
[[]] Maurício Ventura Faria
 
Em 10/05/2019 16:01, Swaroop Joshi escreveu:

How to turnoff SMB1 and disable oplocks.

[SD]

Dear Swaroop,

Building local indexes and switching to local index files can resolve your issue. At-least for reports there could be scope to generate local index files at the start of that particular report. Try to test with one of your report which is significantly getting slowed down. Am sure it will be resolved. If it works then you can work out for the whole software on how to easily and effectively implement with minimal changes. If you want minimal changes to your codes, you may re-build local indexes related to reports at the start of the software

I have gone through this and switching to local indexes resolved it. It's mainly a reporting module, and have used-defined global paths for the dbfs and index files.

Let us know you did what finally to resolve it.

Thanks & Regards,

Swapan

[Anupam]

Dear Swaroop S. Joshi

have you find any solution regarding the slow process on network.

if yes, please tell me what solution you are using and share your experience.

Thanks 

Anupam

[SHAJI THOMAS]

Hi Swaroop,

I have experienced the same thing (slow dbf updation  & report generation in a LAN with nearly 20 computers running simultaneously ) but it is not a Harbour specific problem. My clipper 5.01 program showed exactly the same thing so I can easily understand your problem.

 I found this first when I changed my server from WinXP to Win7 and the experience was EXACTLY SAME as Swaroop described. If the SERVER (dbf installed) is not running the said program then things are quiet stable even if there is more than one client running. From my experience it is HARDWARE related and DBF is not a culprit at least in this case but I do'nt know the reason. I "SOLVED" many cases of the same kind by simply changing SERVER or suspending suspicious client machines. I solved the last issue just before 10 minutes by removing a client machine which was extremely slow (by network card or computer itself). In the last case the issue started when  I changed my program from Clipper to Harbour 3.2 and server changed from WinXP to 

Win7 (32) ( my clipper program was working reasonably ok). 

One thing I should say, in XP there was no such problems with small (below 1 MB) Clipper programs even in low configuration computers(may be because of the change in the architechture).

Regards

 

On Thursday, May 9, 2019 at 12:57:58 AM UTC+5:30, Swaroop Joshi wrote: