Normal Topic Peer to Peer network using Sesame (Read 1930 times)
cbislander
Full Member
***
Offline



Posts: 117
Joined: Mar 22nd, 2018
Peer to Peer network using Sesame
Jul 23rd, 2024 at 12:48pm
Print Post Print Post  
At one of our locations, we have Sesame running as a Server.  It is a Peer-to-Peer setup with the Sesame databases on the main computer with a network connection to another computer.  Our Media says it's because the back computer is running 32bit Windows 10.

Any other ideas?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2492
Joined: Aug 20th, 2003
Re: Peer to Peer network using Sesame
Reply #1 - Jul 23rd, 2024 at 4:36pm
Print Post Print Post  
Other ideas about what? I am not understanding your issue/problem. Can you clarify what issues you are having?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
cbislander
Full Member
***
Offline



Posts: 117
Joined: Mar 22nd, 2018
Re: Peer to Peer network using Sesame
Reply #2 - Jul 26th, 2024 at 4:16pm
Print Post Print Post  
Sorry,

The problem is that the databases take a long time to load up on the second computer.
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2492
Joined: Aug 20th, 2003
Re: Peer to Peer network using Sesame
Reply #3 - Jul 26th, 2024 at 5:41pm
Print Post Print Post  
And you are running Client/Server? The connection count increases when Sesame Client is launched from the 2nd computer? If so there should be no difference in database load time between a local client and a client on another system.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
cbislander
Full Member
***
Offline



Posts: 117
Joined: Mar 22nd, 2018
Re: Peer to Peer network using Sesame
Reply #4 - Jul 29th, 2024 at 1:50pm
Print Post Print Post  
Hi Ray,

Yes, they are running Client Server.  The databases on on the main computer.  The main computer took 5 seconds to load our inventory.  The back computer took 30 seconds to load it.
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2492
Joined: Aug 20th, 2003
Re: Peer to Peer network using Sesame
Reply #5 - Jul 29th, 2024 at 2:56pm
Print Post Print Post  
Can you send me a screenshot of the Shortcut tab of the properties of the Sesame shortcut on the back computer?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
cbislander
Full Member
***
Offline



Posts: 117
Joined: Mar 22nd, 2018
Re: Peer to Peer network using Sesame
Reply #6 - Jul 29th, 2024 at 3:32pm
Print Post Print Post  
Hi Ray,

Is this what you want?
  

ses-short.png ( 66 KB | 44 Downloads )
ses-short.png
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2492
Joined: Aug 20th, 2003
Re: Peer to Peer network using Sesame
Reply #7 - Jul 30th, 2024 at 2:08pm
Print Post Print Post  
That is the proper switches, but the only data sent to a client during the load is the progress for the progress meter so there should be no time difference between the clients on a load. What you can do is in the Sesame.ini file on the Server computer add the following line.

DATABASE RETENTION: ON

Then once the database is loaded on the server, opening it should be nearly instantaneous on the back computer.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
cbislander
Full Member
***
Offline



Posts: 117
Joined: Mar 22nd, 2018
Re: Peer to Peer network using Sesame
Reply #8 - Jul 31st, 2024 at 1:37pm
Print Post Print Post  
Hi Ray,

I gave it a try.

I added the line to the Sesame.ini file on the computer is the Server  (not the Client). I copy and paste the file below and saw the line I added was already there.

// SESAME.INI FILE. ONLY LINES THAT START ON THE LEFT MARGIN, WITHOUT //, ARE ACTIVE.
//  SO TO MAKE A LINE ACTIVE DELETE BOTH THE // AND THE SPACE, LIKE THE LINES BELOW ..

QUICK START: OFF            // DISPLAYS QUICK START MENU ON STARTING SESAME
BLINK: OFF                  // CURSOR BLINK
GLOBAL AUTOCOMPLETE: OFF      // PROMPT WITH EXISTING VALUES AS YOU TYPE IN A FIELD
HIGHLIGHT ON ENTER: OFF            // IF SET TO "ON" SELECTS FIELD VALUES ON ENTRY

// MENU STYLE OPTIONS
MENU STYLE: BUTTONS            // "BUTTONS" or "TREE"
// MENU STYLE: TREE            // USE THIS TO REVERT TO PREVIOUS MENU TREE STYLE
DATABASE RETENTION: ON

// DICTIONARY OPTIONS
INTERACTIVE SPELL CHECKING: OFF        // CHANGE TO "ON" FOR SPELL CHECKING AS YOU TYPE
// DICTIONARY PATH: C:\Sesame2\Dictionary.txt      // CAN BE USED TO SPECIFY ALTERNATIVE DICT. FILE


// THESE CAN BE USED TO FIX SIZE & POSITION OF THE SESAME WINDOW ..
// THE MEASUREMENTS ARE IN PIXELS, AS IS YOUR SCREEN RESOLUTION, eg 1024 x 768
// WIDTH: 900
// HEIGHT: 610
// X: 105      // MEASURED FROM TOP LEFT OF THE SCREEN
// Y: 80      // MEASURED FROM TOP LEFT OF THE SCREEN


// THESE CAN BE USED TO SET THE SESAME COLORS ..
// BACKGROUND COLOR: 236 233 216            // MAIN SESAME BACKGROUND
// SECONDARY BACKGROUND COLOR: 255 255 255    // BACKGROUND OF MENU TREE ETC

// MENU FONT:  Tahoma
// MENU FONT SIZE: 11

// SETS THE WIDTH OF THE TABLE ROW HEADER, including subforms.
TABLE ROW HEADER WIDTH: 40

// Makes scrollbars for forms, table view more distinctive. Cannot have a comment on same line.
SLIDER BOX STYLE: UP

// Affects vertical scrollbar for the menu tree. Does not affect form scrollbars
DEFAULT SCROLLBAR WIDTH: 16

// SETTINGS USED IN SESAME DESIGNER ...

SNAP TO GRID: OFF
GRID WIDTH: 8
GRID HEIGHT: 8

PROGRAM EDITOR FONT SIZE: 12

// THIS ENABLES PAGE BREAKS IN REPORTS IN HTML PREVIEW MODE INSTEAD OF A VISUAL REPRESENTATION OF THE PAGE BREAK
REPORT PAGE BREAK ALWAYS: ON
DATABASE RETENTION: ON


I shut down the server and started it again.  After unlocking the databases, I tried to load our inventory database on both.

The main computer took 5 seconds and the client computer still took 30 seconds.

  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2492
Joined: Aug 20th, 2003
Re: Peer to Peer network using Sesame
Reply #9 - Jul 31st, 2024 at 4:43pm
Print Post Print Post  
Shoot me over an email and we can set up a call when you are available so that I can remote onto your systems and see your setup.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged