WebSpeed Performance Question

[Chris Kelleher]

We have a complex character (telnet/host/terminal) integrated
application with several WebSpeed interfaces. We are using WS3.0 and
V9Db connected in shared memory on SCO Unixware with Apache. We have
used our existing 4GL code (as much as possible) run as embedded
speedscript. There is a performance issue I would like comments on.

With simple transactions, say user fills in HTML form with Order Entry
details, submits, creates one record in one table and WS TRNSVR returns
an updated web page with allocated Order Number, we get a transaction
time under two seconds. Given the interaction with Web Server, TRNSVR,
etc this seems reasonable

The performance issue occurs when we run the programs to allocate stock,
update debtors, general ledger etc. These additional .p's update several
tables and perform complex transactions. They add only about 0.25 of a
second when we run them in the character interface in host/terminal mode
on same server against same Db, using the same code. However if we
insert this code into our WebSpeed interface they add 3 seconds to
execution time ie over 10x slower than character. The code is very
efficient, running in multiple sites for many years, so doesn't seem to
be a coding/indexing issue.

This is leading us to conclude that if you want sub two second
performance WebSpeed code has to architected to only run the simplest
transactions and all back end processing must be run on an AppServer or
batch mode or similar.

Do other WebSpeed developers experiences correspond with ours?

Paul Royse
Applied Logic Systems
Auckland, New Zealand
paul@applog.co.nz <maimailtoaul@applog.co.nz>

 

[Chris Kelleher]

And do not forget to look if Webspeed is accessing the r-code of your
application. Otherwise the code has to be compiled on the fly by each of
your agents (separate client sessions)! Use the propath section from the
webtools to look for your program and see what is found in propath.
Regards,
Mike Fechner

 

[Chris Kelleher]

I would definitely do some more probing around. It should run the
same. Check all of your parameters, memory usage, etc. Is there any
difference in the speed/memory of the box WebSpeed is on and its network
connection to the database?

If your host-based stuff is running on the same machine as the database,
but your WebSpeed stuff is not, then that is the biggest cause of the
difference. Your bottleneck may be the network connection. Perhaps
some tuning of queries and addition of a FIELDS phrase would help that.

Good luck with it


--
Steve Southwell
Web Programmer / Consultant
United Systems, Inc. http://www.usiatl.com
Phone: (214) 488-2239