Panorama Server Speed Issues

[James Cook]

I can address some of this but Jeff will need to speak for himself 
regarding server specifics...

>You don't really say whether you are talking about database sharing 
>or web publishing

100% web publishing. Jeff's references to "client" is in regard to 
customers whose web sites he hosts, not client/server type clients.

>  > functions often take a number of seconds

Some sites have databases with 100,000 records in which every record 
needs to be searched. Even on fast cpu's it takes several seconds to 
conduct a search and crunch the results. With some of these databases 
growing regularly, we're looking hard at how to grease every wheel 
before customers start jumping ship.

>I think you may be talking about web publishing -- I know that you do
>that. The Panorama Enterprise code is already written to minimize screen
>drawing pretty much as much as possible.

Unlike shared files, web published files display a form on the 
server. With 30 or more databases open, there is screen activity as 
windows come to the front and the menus are redrawn. It's split 
seconds to be sure, but when traffic is high and the databases are 
big they're all straws on the back of the speed camel.

Opening and closing 30 MB files is out of the question in regard to speed.

>If functions are taking a number of seconds, that has to be in your
>code. If we are talking about web publishing function, then I would
>think that the code would be under your control.

Only so far.  I've run tests to see if it's faster to search then use 
arrayselectedbuild versus an arraybuild and no search. (Selecting 
with arrayselectedbuild is faster) I've got it caching the last 50 
searches in order to reduce the number of new searches, etc. I'm 
still looking for ways to minimize the data processed and methods to 
accelerate my procedures but there's not much more paring available.

-- 
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