Panorama Server Speed Issues

[James Cook]

At 6:27 PM -0800 3/2/08, James Rea wrote:
>  > None of the code on these particular servers is written by me, so I
>>  have no control other than making recommendations. And the data is
>>  from many different clients, so it is near impossible to have much
>>  influence there.
>
>Ouch. So you are essentially running a Panorama Enterprise hosting
>service. Unfortunately it isn't really that well set up for that, since
>all of your clients have to share memory, namespace, etc.

Another one that I can respond to...

Jeff is running a hosting service, but most of his machines are 
dedicated to running a single product that I wrote for use on 
Enterprise. Some machines have a dozen or so such sites, but 
customers don't have access to the databases other than through 
interfaces I've written. The system is set up to provide each 
client's files with their own name set.

They can and do upload data to their copy of a searchable database 
but here too it's via a browser interface I've written, not directly 
through Enterprise.

The file names, variables and control of quitting are out of their reach.  :-)

It's when they start getting up to 100,000 records that the searches 
really bog down. I've noted your comments about field structure and 
searches. I'm mostly in compliance, but there are some occasionally 
used fields that are near the end of the databases. I'll move them 
forward.

>  My recommendation would be to save with just the data sheet open. The
>Enterprise server normally turns off data display in the data sheet.

Regarding the Datasheet, it doesn't display anything, but it doesn't 
disable the keyboard. Accidental input can be deadly to some files. 
Ideally a web server never has anyone on the keyboard, most don't 
even have keyboards or monitors attached. But in practice, it's often 
necessary to log on via VNC to work on settings or others aspects of 
running a server. It's just too easy to type at a wrong moment and 
alter crucial data.

I've resorted to saving all web published files with a tiny, blank 
form displayed. Some of Jeff's servers have a stack of 30 or more of 
these forms with the display busily popping one or another along with 
their menus to the forefront. It's that bit of screen drawing - the 
interface with the video - that Jeff was ultimately asking about 
disabling.


BTW, Panorama Enterprise  runs perfectly in the foreground or the 
background. That issue was addressed long ago. It's manners have been 
just fine.

It's also worth noting that Enterprise has run all of these sites 
with a very high degree of reliability.  It has been rock solid.

-- 
James Cook
JC at JamesCook.biz
720-252-7042

Proficiencies
http://JamesCook.biz

Founder of HindSight Ltd.
http://HSLtd.us

Custom Panorama Applications
Specializing in Panorama Enterprise for the Web