how to process quicker in client-server setup.

my app is in xhb+dbf+ps32+wvw
app folder(in server) E:\MYTAX (or C:\MYTAX or D:\MYTAX)
exe file E:\MYTAX\THETAX.EXE
ALL exe/dbf templates... files are hosted in server's \MYTAX folder. (and subfolders)
each client/terminal is mapped to E:\MYTAX (of the server)
on each client's desktop,the shortcut/icon properties are:
Target: Z:\MYTAX\THETAX.exe
StartIn: Z:\MYTAX
(E: of the server is mapped as Z: on this user's desktop. the full E: of the server is mapped)

in my app, user can create 100 companies for accounting - each company identified with a 2 char code.
e.g. 01 / AA / A1 ....
data of each company is saved in a subfolder [company 01 data(dbf,ntx,xlsx...) will be saved in \MYTAX\01 folder, company AA data will be saved in \MYTAX\AA folder...]
THETAX.EXE will be residing ONLY in E:\MYTAX of the server.

**********
proce main
**********
cls
....
....
companyselection() && user selects from 01 / AA / A1 ...

setdefault=diskname()+':\mytax\'+compani ('compani' is the variable for the selected company e.g. 01 / AA / A1...)
set defa to &setdefault
-so if company 01 is selected, setdetault will be Z:\MYTAX\01

:voucher report
sele 0
use Taxfile inde taxfile1, taxfile2, taxfile3, taxfile4, taxfile5 (taxfile.dbf size: 442000 records)
(taxfile.dbf/.ntx is residing in z:\mytax\01 folder)
sele 0
use xxxxx inde xxxx1, xxxx2....
sele 0
use yyyy inde ...
sele 0
use zzzz inde zzzz,...,....
sele 0
.....
sele 0
....

sele Taxfile
do whil field7=abcdef .and. taxdate<=duedate .and. !eof()
sele xxxx
seek taxfile->client
sele yyyy
seek taxfile->gstnumber
sele zzzz
seek taxfile->citycode
sele Taxfile
...
...
:report processing...
....
skip
end

now, if the app is run at/from the server, this voucher report takes 124 seconds to process (891 pages)
BUT, if any client/terminal generates the 'same' report, it takes 800+ seconds...WHY?
even saving a record to a .dbf file(119 fields) takes 1 second on the server, the 'same' takes 14 seconds from any client/terminal.

Il 27/01/2023 12:03, timepro timesheet ha scritto:

> even saving a record to a .dbf file(119 fields) takes 1 second on the server, the 'same' takes 14 seconds from any client/terminal.

It is not normal. You need to check your code and/or your network hardware.

--
Enrico Maria Giordano

http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

On Friday, January 27, 2023 at 4:40:22 PM UTC+5:30, Enrico Maria Giordano wrote:
> Il 27/01/2023 12:03, timepro timesheet ha scritto:
>
> > even saving a record to a .dbf file(119 fields) takes 1 second on the server, the 'same' takes 14 seconds from any client/terminal.
> It is not normal. You need to check your code and/or your network hardware.
>
> --
> Enrico Maria Giordano
>
> http://www.emagsoftware.it
> http://www.emagsoftware.it/emgmusic
> http://www.emagsoftware.it/spectrum
> http://www.emagsoftware.it/tbosg
emg:

seems the bottleneck is in my system design.
the time consuming/slow process happens at more than 30+ diff. locations where my app is installed.

-is my client-server mapping procedure proper/standard.
-could it be an issue with 'set default to...'
-what is YOUR client/server setup. do you install your .exe file in each client/system. (besides the server)
-from each of your client/terminal, how do you access,open,update,process... data/files residing in the server

Il 27/01/2023 13:12, timepro timesheet ha scritto:

> emg:
>
> seems the bottleneck is in my system design.
> the time consuming/slow process happens at more than 30+ diff. locations where my app is installed.
>
> -is my client-server mapping procedure proper/standard.

I don't know.

> -could it be an issue with 'set default to...'

Not that I'm aware of.

> -what is YOUR client/server setup. do you install your .exe file in each client/system. (besides the server)

I install everything in the server disk (EXE, DBF, etc.). The clients
have only a desktop link to the shared EXE.

> -from each of your client/terminal, how do you access,open,update,process... data/files residing in the server

Nothing special. I only pay attention to properly lock records, but this
cannot slow down the DBF access.

--
Enrico Maria Giordano

http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

Back to old OpLocks and SMBx network configuration...
Lot of posts to read.
Claudio H

On Friday, January 27, 2023 at 7:00:37 PM UTC+5:30, Enrico Maria Giordano wrote:
> Il 27/01/2023 13:12, timepro timesheet ha scritto:
>
> > emg:
> >
> > seems the bottleneck is in my system design.
> > the time consuming/slow process happens at more than 30+ diff. locations where my app is installed.
> >
> > -is my client-server mapping procedure proper/standard.
> I don't know.
> > -could it be an issue with 'set default to...'
> Not that I'm aware of.
> > -what is YOUR client/server setup. do you install your .exe file in each client/system. (besides the server)
> I install everything in the server disk (EXE, DBF, etc.). The clients
> have only a desktop link to the shared EXE.
> > -from each of your client/terminal, how do you access,open,update,process... data/files residing in the server
> Nothing special. I only pay attention to properly lock records, but this
> cannot slow down the DBF access.
> --
> Enrico Maria Giordano
>
> http://www.emagsoftware.it
> http://www.emagsoftware.it/emgmusic
> http://www.emagsoftware.it/spectrum
> http://www.emagsoftware.it/tbosg

emg, would you please:

(in your client/server setup)
-with your 'shared' .exe, do you store/save ALL your .dbf files in the server ONLY - no matter which client/system inputs/accesses the .dbf.

-inside your .prgs, do you use 'set relation to' to open/use .dbf files

-do you map only the folder your app. resides in -or- the full drive of the server where your app's folder is resident.
i.e. if your app is residing in C:\EMGTAX folder of the server. for the client system, do you share & map the FULL C: of the server or only C:\EMGTAX folder.

thanks you.

Il 31/01/2023 11:29, timepro timesheet ha scritto:

> emg, would you please:
>
> (in your client/server setup)
> -with your 'shared' .exe, do you store/save ALL your .dbf files in the server ONLY - no matter which client/system inputs/accesses the .dbf.

Yes.

> -inside your .prgs, do you use 'set relation to' to open/use .dbf files

I usually use SET SCOPE but SET RELATION is also fine. You have to
isolate the code that causes the slow down. There is no other way to
understand the problem.

> -do you map only the folder your app. resides in -or- the full drive of the server where your app's folder is resident.

It is irrelevant.

--
Enrico Maria Giordano

http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

On Tuesday, January 31, 2023 at 4:46:29 PM UTC+5:30, Enrico Maria Giordano wrote:
> Il 31/01/2023 11:29, timepro timesheet ha scritto:
>
> > emg, would you please:
> >
> > (in your client/server setup)
> > -with your 'shared' .exe, do you store/save ALL your .dbf files in the server ONLY - no matter which client/system inputs/accesses the .dbf.
> Yes.
> > -inside your .prgs, do you use 'set relation to' to open/use .dbf files
> I usually use SET SCOPE but SET RELATION is also fine. You have to
> isolate the code that causes the slow down. There is no other way to
> understand the problem.
> > -do you map only the folder your app. resides in -or- the full drive of the server where your app's folder is resident.
> It is irrelevant.
> --
> Enrico Maria Giordano
>
> http://www.emagsoftware.it
> http://www.emagsoftware.it/emgmusic
> http://www.emagsoftware.it/spectrum
> http://www.emagsoftware.it/tbosg
thanks emg:

'You have to isolate the code that causes the slow down...'
that's exactly what/where i can't figure out.
reckon, will read each line of my prgs & visualise the outcome...
(it could be very elementary if i isolate it/stumble upon.)

emg, may i get a sample of your app's icon properties (app icon on the client/terminal)
(target & startin)

Il 31/01/2023 13:46, timepro timesheet ha scritto:

>> You have to isolate the code that causes the slow down...
>
> that's exactly what/where i can't figure out.
> reckon, will read each line of my prgs & visualise the outcome...
> (it could be very elementary if i isolate it/stumble upon.)

You have to put some alert around so you can figure out the bottleneck code.

> emg, may i get a sample of your app's icon properties (app icon on the client/terminal)
> (target & startin)

Nothing special:

\\myserver\midisk\myfolder\myexe.exe
\\myserver\mydisk\myfolder

--
Enrico Maria Giordano

http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg