(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › File sizes, and speed
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) File sizes, and speed (Read 1883 times)
Boneyard_Scrounger
Junior Member
**
Offline


Canadian Government =
Elected Dictatorship

Posts: 88
Location: Peoples Republic of Kanada
Joined: Apr 20th, 2005
File sizes, and speed
Apr 28th, 2005 at 7:43pm
Print Post Print Post  
I have one app, that has a 20.8Mb dat file.
This is the one that is slow to load.
We are investing in a considerably faster serving computer, with a much larger drive capacity, but I wonder, why this one file is so large. It has more LEs that any other app I'm running. Should I be looking at a way to cut down on the LE's? or is there another way?
There are close to three hundred LE's in one form on this one App.
  
Back to top
WWW WWW  
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: File sizes, and speed
Reply #1 - Apr 29th, 2005 at 12:58pm
Print Post Print Post  
Eliminating unnecessary LE is usually the best way to reduce the size of an application. Q&A did not provide variables or temporary storage of any kind. By eliminating LEs that should be unbound (but in Q&A were not), or were used to hold calculations, or used temporarily for programming, the typical large programmed Q&A form can be reduced by about one third.

So yes, eliminating unneeded LEs is a good thing to do over and beyond load speeds. If you are running client/server, you can also seek to reduce the frequency of loading in general.  In Q&A, the user selects an operation and afterwards selects the database to operate on. This approach causes loading and reloading in Sesame. Sesame intends to load an application and then allow operations on that application without any further reloading / reselection.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Boneyard_Scrounger
Junior Member
**
Offline


Canadian Government =
Elected Dictatorship

Posts: 88
Location: Peoples Republic of Kanada
Joined: Apr 20th, 2005
Re: File sizes, and speed
Reply #2 - May 2nd, 2005 at 4:00pm
Print Post Print Post  
Currently running a 2Gig proccesor and 960MB ram.
This one aplication takes a good two minutes to load.
The number of forms on this app is quite small, but it is very heavy on LE's.

If possible, I'd like to transfer out some of the LE's to a separate app. or even another form. Is there a way?
  
Back to top
WWW WWW  
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: File sizes, and speed
Reply #3 - May 2nd, 2005 at 7:14pm
Print Post Print Post  
Standalone or client/server?
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Boneyard_Scrounger
Junior Member
**
Offline


Canadian Government =
Elected Dictatorship

Posts: 88
Location: Peoples Republic of Kanada
Joined: Apr 20th, 2005
Re: File sizes, and speed
Reply #4 - May 2nd, 2005 at 7:39pm
Print Post Print Post  
That's the server, it's a wireless network, of three, but they all run about the same speed openning that one app.
  
Back to top
WWW WWW  
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: File sizes, and speed
Reply #5 - May 2nd, 2005 at 7:52pm
Print Post Print Post  
How long does it take opening it standalone (not client/server) when the application file (the .db) and Sesame are on the same harddrive (no net paths)?
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
John_Y_Cannuck
Junior Member
**
Offline


decidedly un-geek!

Posts: 97
Location: Lindsay Ontario Canada
Joined: Mar 8th, 2004
Re: File sizes, and speed
Reply #6 - May 3rd, 2005 at 10:54pm
Print Post Print Post  
When I'm running it on the server, and that's the fastest machine, the command line is the default, it does not go through the server, although the server is in memory.
The client machines open that particular app at about the same speed as the much faster server. The client machines are 1.5 gig and 1.2 gig with about 600 some odd meg ram each.
  
Back to top
WWW WWW  
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: File sizes, and speed
Reply #7 - May 4th, 2005 at 11:55am
Print Post Print Post  
I am trying to determine if this is a client/server configuration issue. That is why I am asking you to load the application file completely and absolutely standalone - with no server, no client, no networking of any kind. Simply, start Sesame on a computer that has the application on its C:\ drive, and load the application from the C:\ drive. Make absolutely sure that there is no client or server running. Make absolutely sure that the hard drive you are using is local and not on the network.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Boneyard_Scrounger
Junior Member
**
Offline


Canadian Government =
Elected Dictatorship

Posts: 88
Location: Peoples Republic of Kanada
Joined: Apr 20th, 2005
Re: File sizes, and speed
Reply #8 - May 4th, 2005 at 1:07pm
Print Post Print Post  
Ok with all the other machines shut down, and just the server machine running, and Sesame's server not loaded, the speed on the app is down to 30 seconds. That's after a clean boot, so should be best speed.
  
Back to top
WWW WWW  
IP Logged
 
Boneyard_Scrounger
Junior Member
**
Offline


Canadian Government =
Elected Dictatorship

Posts: 88
Location: Peoples Republic of Kanada
Joined: Apr 20th, 2005
Re: File sizes, and speed
Reply #9 - May 4th, 2005 at 1:09pm
Print Post Print Post  
with the sesame server loaded, but the client machines shut down, the speed is the same, about 30 seconds.
  
Back to top
WWW WWW  
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: File sizes, and speed
Reply #10 - May 4th, 2005 at 1:29pm
Print Post Print Post  
If running standalone (no client or servers running), it takes 30 seconds, but takes two minutes to load if running client/server - there is no doubt, the client/server configuration is not correct. Usually, this means that one or more of your clients are telling the server to load from the client's local harddrive, or through a mapped harddrive. That will force the entire application through the network during loading. That is almost always unnecessary and should be avoided.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Boneyard_Scrounger
Junior Member
**
Offline


Canadian Government =
Elected Dictatorship

Posts: 88
Location: Peoples Republic of Kanada
Joined: Apr 20th, 2005
Re: File sizes, and speed
Reply #11 - May 4th, 2005 at 2:04pm
Print Post Print Post  
You are probably right, see my post under network issues, I'm in trouble this morning.
  
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge