MS Small Business Server 2003 & Btrieve

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

.

Relevant Pages

  • Re: What doesnt lend itself to OO?
    ... >> proxy and instructs the server to constuct the real object. ... rather than client code. ... If 'clock' is instantiated in the server, ... > for the server interface at the OOA level. ...
    (comp.object)
  • This is going straight to the pool room
    ... or not the client has privilege to do what they're trying to do, ... The server environment is this: ... 3GL User action Routines that Tier3 will execute on your behalf during the ... Routine Name: USER_INIT ...
    (comp.os.vms)
  • Re: remoting - nasty bug?
    ... > can reference the server through this address.. ... > although I cannot connect to the server with my client. ... HOSTS file is located in "%SystemRoot%\system32\drivers\etc" for WindowsNT ... There are various considerations while writing a channel. ...
    (microsoft.public.dotnet.framework.remoting)
  • [Full-Disclosure] R: Full-Disclosure Digest, Vol 3, Issue 42
    ... Full-Disclosure Digest, Vol 3, Issue 42 ... SD Server 4.0.70 Directory Traversal Bug ... Arkeia Network Backup Client Remote Access ...
    (Full-Disclosure)
  • Re: What doesnt lend itself to OO?
    ... > rather than client code. ... no way to do that without also touching the object with clock semantics ... will not encapsulate both clock semantics and network semantics. ... The server can do whatever it wants ...
    (comp.object)