Hot Topic (More than 10 Replies) Network Speed (Read 1456 times)
UPaul42
Junior Member
Members
**
Offline


been a Q&A user/programmer
since version 2.0

Posts: 57
Location: Broad Brook CT
Joined: Jul 23rd, 2003
Network Speed
Dec 7th, 2010 at 4:00pm
Print Post Print Post  
I have a three user Sesame Server setup.
The Sesame Server is on a desktop, windows XP, 4MB ram, no user, with the application on this server.
The networking is Windows Workgroup and all users are running XP.
The application has one subform, naturally linked with the subform db inside the application.
There is a global load on SBasic (only used for reports).
The users are also using a Netware Client to access their regular server.
With one user, the time from record to record is slow (6-8 seconds)

1. Is loading SBasic globally slowing this down?
2. Is natural linking slowing this down?
3. Is Windows Workgroup slowing this down?
4. All of the above?

Other ideas?
  

&&http://www.lantica.com/images/sespro_badges/sespro3.gif&&Paul Anderson&&President&&Systems-Consulting&&89 Main Street, Broad Brook CT 06016&&(860) 627-5393&&Sales@Systems-Consulting.com
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Network Speed
Reply #1 - Dec 7th, 2010 at 7:28pm
Print Post Print Post  
Hello Paul,

How big is the application? Both in MB and Number of Records?
If you run Sesame standalone on the Server computer how quickly does it move through the records?
What do you mean by loading SBasic globally?

-Ray
  

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


been a Q&A user/programmer
since version 2.0

Posts: 57
Location: Broad Brook CT
Joined: Jul 23rd, 2003
Re: Network Speed
Reply #2 - Dec 9th, 2010 at 2:07pm
Print Post Print Post  
Ray,

The application is currently 39K in size with 13 records.
Running standalone runs just fine.
Global load of SBasic is shown below.

Global Programming
CloseCommandArea(1)
#include "sbasic_include.sbas"

I can send the complete application for you to look at, if you wish.
  

&&http://www.lantica.com/images/sespro_badges/sespro3.gif&&Paul Anderson&&President&&Systems-Consulting&&89 Main Street, Broad Brook CT 06016&&(860) 627-5393&&Sales@Systems-Consulting.com
Back to top
IP Logged
 
proudpoppy
Full Member
Members
***
Offline


Do What ??

Posts: 420
Location: South Carolina
Joined: Apr 7th, 2004
Re: Network Speed
Reply #3 - Dec 9th, 2010 at 3:52pm
Print Post Print Post  
Just wondering is it a wired network or wireless, and the network router type, may want to check the task manager, network performance tab to see if something is going on. I run basically the same set up but with thousands of records and I have no slowdown between records such as you indicated. I have found that using xp as a server machine that it pays to reboot occasionally, and sometimes a reset on the router.
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Network Speed
Reply #4 - Dec 9th, 2010 at 5:43pm
Print Post Print Post  
Hello Paul,

If you run a client on the Sesame Server computer does it slow down as well? or is it only Sesame clients from other computers that are slow?

That code in Global Code is perfectly fine and will not affect speed of moving between records.

-Ray
  

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


been a Q&A user/programmer
since version 2.0

Posts: 57
Location: Broad Brook CT
Joined: Jul 23rd, 2003
Re: Network Speed
Reply #5 - Dec 9th, 2010 at 6:05pm
Print Post Print Post  
Clients from other computers are slow. The rest of the network seems to work at normal speed for everyone, only this Sesame Server.
  

&&http://www.lantica.com/images/sespro_badges/sespro3.gif&&Paul Anderson&&President&&Systems-Consulting&&89 Main Street, Broad Brook CT 06016&&(860) 627-5393&&Sales@Systems-Consulting.com
Back to top
IP Logged
 
proudpoppy
Full Member
Members
***
Offline


Do What ??

Posts: 420
Location: South Carolina
Joined: Apr 7th, 2004
Re: Network Speed
Reply #6 - Dec 9th, 2010 at 6:18pm
Print Post Print Post  
I have 7000 records with two sub-forms natural linked and the time between record changes is less than 1-sec. XP server, and 4-clients.
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Network Speed
Reply #7 - Dec 9th, 2010 at 6:35pm
Print Post Print Post  
Hello Paul,

Any Anti-Virus or Internet Security Programs running on Client or Server computers?

-Ray
  

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


been a Q&A user/programmer
since version 2.0

Posts: 57
Location: Broad Brook CT
Joined: Jul 23rd, 2003
Re: Network Speed
Reply #8 - Dec 9th, 2010 at 7:00pm
Print Post Print Post  
Yes,

On all
  

&&http://www.lantica.com/images/sespro_badges/sespro3.gif&&Paul Anderson&&President&&Systems-Consulting&&89 Main Street, Broad Brook CT 06016&&(860) 627-5393&&Sales@Systems-Consulting.com
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Network Speed
Reply #9 - Dec 9th, 2010 at 7:31pm
Print Post Print Post  
Try temporarily disabling them on both Client and Server and see if the slowdown goes away.

-Ray
  

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


been a Q&A user/programmer
since version 2.0

Posts: 57
Location: Broad Brook CT
Joined: Jul 23rd, 2003
Re: Network Speed
Reply #10 - Dec 13th, 2010 at 3:18pm
Print Post Print Post  
Ray,

I did a test with the Anti-Virus temporarily off and the speed went to normal.
I went bank to the server and placed exceptions for the AV to exclude monitoring the sesame EXEs and the datafiles including the dsr, etc.
All is normal now
Thanks for your help.
  

&&http://www.lantica.com/images/sespro_badges/sespro3.gif&&Paul Anderson&&President&&Systems-Consulting&&89 Main Street, Broad Brook CT 06016&&(860) 627-5393&&Sales@Systems-Consulting.com
Back to top
IP Logged