Quote:


Server.

Quote:


Server again.

Quote:


The only access that requires the database to load is the first access. That is why some folks like to pre-load the application. Once it is loaded, it does not matter which forms or databases are opened.

Quote:


Sesame is server heavy - meaning that you want the server to be as powerful as possible. If you can, try to free up memory on the server form Sesame's use, by eliminating processes and applications that you do not directly need. Also make sure that the swap file is pre-allocated - do not use dynamic allocation. Set the swap file as large as you can afford (at least twice physical memory). After you are up and running and activity is "typical" - check to see if the Sesame server is swapping. If so, add more RAM.

Also, the Sesame server is multithreaded. That means that, if provided with more than one CPU, Sesame server will take advantage of the additional power in an almost linear way.

If you can, try to optimize network access bottlenecks. For example, making the Sesame server that same machine you are using to be a file server (under MS) will route all of your traffic to the narrowest point. Try to distribute your network load as widely as possible. Try to use switches instead of hubs.

Clients need not be very powerful at all. There are only a handful of operations that can tax the client computer.

Quote:

Thanks for the info.

What is more important, disk seek time or Ram.

At present I am using a machine that has IDE 7200 and a gig of Ram as the server.

I have a unit I can use that has very fast SCSI Swallow drives but limited to low maximum Ram of 256.
 

Hopefully this will be a temporary server. If the application works correctly I should be looking to purchase a new machine running Linux to use as the server.

Thanks

Quote:



Heck, if I upgraded to all that good stuff then all I would need to create a really good application is someone who really knows how to use Sesame and Sbasic properly to create it.

???That sounds like Ray

Hmm Is Ray looking for work? I hear from horse lovers that riding is beautiful in California all year round. 

Quote:


Luckily, for me otherwise I could be on the next plane to California, Olya doesn't read the forums. Besides what would I do with all my tractors? 

Plus I would need a pair of bolt cutters to cut the chain to the desk, and then I would have to get by Erika who says I can't leave, and then I would probably have to figure out how to drive my car with broken legs after being tossed down the stairs (Erika may look small but that would make her mad, plus you have seen these stairs, it would hurt). You know what I think it is easier to stay here.

Vacation in California, well that is a different story.

Quote:


What kind of internet connection?

The time to run the following code with a subform with 30 fields, making 99 new records:

var aa as int
var bb as int
var dd as int
var fn as string
var val as string

writeln(@ServerTime())
for bb = 1 to 99
	  for aa = 1 to 30
		    fn = "a" + @Str(aa)
		    val = "Whatever you say " + @Str(aa)
		    FormFieldValue("NewForm", fn, bb, val);
	  next
	  dd = @FormNewRecord("NewForm")
next
writeln(@serverTime())
 

Using Sesame 1.1.3 Table View: 123 seconds (1.23 seconds per record)
Using Sesame 1.1.3 Form View: 14 seconds (0.14 seconds per record)
Using Sesame 2.0.0 Table View: Less than 1 second (0.004 seconds per record)
Using Sesame 2.0.0 Form View: 15 seconds (0.15 seconds per record)

This a Pentium 2 / 500 Mhz with 128 Meg of RAM.

Quote:

Standalone.
Quote:


1.1.2 and 1.1.3 are about the same for this.