When moving an established application from a peer-to-peer network of
W2k and XP machines to a client-server architecture using SBS 2003 we
have suffered a performance degradition using both Pervasive 2000i and
9.1 using transactional access only.

When run locally on the server, programs generally run twice as fast
since the server is far more powerful than the former data host
computer; however when run from a client, the response goes from 0:15
to 1:45 on a particular program. Strangely, if you connect to the
server using terminal services from the same LAN client, the test runs
faster - on the order of 0:45. Not as fast as local (or pre SBS), but
quite an improvement! The problem is not restricted to one program,
but is apparent across the entire application. Report programs with
sorts appear to be more affected than online screens - likely due to
the higher volume of data.

Ping time from client to server is under 1ms. You can Telnet from the
client to the server on port 3351. Downloading a 9MB file from the
server takes ~ 2 seconds. TCP/IP is the only protocol involved and the
client's HOSTS file includes the server's fixed IP.

Any thoughts would be appreciated. Pervasive tech support cannot find
the answer...

Try running the Pervasive SYstem Analyzer Network Communications Test
from the client to the server. Be sure to go into "Advanced" settings
and select TCP only, and set it for 2000 test packets.

While running, watch the screen count -- the counting should be fast
and smooth. If it runs slowly, or if you see it pause (any pause of
more than 1/4 second indicates a lost network packet), then you are
experiencing networking problems. Double-check NIC settings, duplex
settings, and other items to see what might be amiss.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Sydney: Pervasive.SQL Service & Support Class - 02/27/06 ***
*** Chicago: Pervasive.SQL Service & Support Class - 03/27/06 ***

Arch wrote: