1. Forum
  2. Usenet
  3. COMP.LANG.XHARBOUR

  • quicker processing in client-server setup

    From timepro timesheet@21:1/5 to All on Fri Jan 27 03:03:49 2023
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Fri Jan 27 12:10:19 2023
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to Enrico Maria Giordano on Fri Jan 27 04:12:16 2023
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Fri Jan 27 14:30:36 2023
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claudio H@21:1/5 to All on Fri Jan 27 07:03:16 2023
    Back to old OpLocks and SMBx network configuration...
    Lot of posts to read.
    Claudio H

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to Enrico Maria Giordano on Tue Jan 31 02:29:35 2023
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Tue Jan 31 12:16:27 2023
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to Enrico Maria Giordano on Tue Jan 31 04:46:18 2023
    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)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Tue Jan 31 14:20:43 2023
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)