Hello,

I'm testing a new workstation (Dell Precision Windows 7 64 bits)
I need to connect to a Netware 5.1 server with Psql 8.5
Everything goes fine immediatly after login but the file opening need
more an more time the more I open files
say in a XP workstation opening all my tables takes 1 second, on the
Win7, it can take up to 30 seconds (at that moment, I logoff, logon to
get it working correctly)

I get the same problem when connecting to a Debian server with PSQL
9.5

I have to logoff/logon (windows) to get an acceptable speed.

I tried several things to speed up but no luck.
Cannot use V10 client as I need Odbc connection to the server.

Does someone have an advice so I can work on may WS ?

Regards
Hubert

The first thing to find out if whether this problem is systemic to the
server or to the workstation. One way to do this is to try installing a
network analyzer like Wireshark (www.wireshark.org) and capture the
network trace to see what is taking so long, then trying to reconfigure
the workstation to avoid that problem.

Another possibility would be to look to upgrading the entire environment
to PSQLv10, which is the ONLY version certified on Windows 7. However,
PSQLv10 is not available for NetWare, so this wqould require changing to
either Windows or Linux as a server NOS.

A final possibility would be to install and use Windows XP Mode, a
feature of Windows 7 that runs applications in a virtual WinXP box. I
have had several users report success with doing this on Windows 7 with
older Pervasive clients. It's not as transparent, but it works...
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive Training - June 2010 in Chicago ***


hbannw wrote:

Hello Bill,

actually, I cannot upgrade to PSQLv10, this is planned for this
summer. (SLES10 and PSQLv10)

I will give a try to XP Mode but it is not my preferred option

I will also try the PSQLV10 client, are there restrictions connecting
to V8.5 ?

I suppose the problem comes from the workstation as after the logon,
everything is fine.


Here a small extract from the capture done with Wireshark when it does
not work
this is just after get effective rights for a file
13994 0.232743 WORKSTATION SERVER NDS C NDS Read Entry Information,
Object Name - xx.XX
13995 0.232975 SERVER WORKSTATION NDS R Ok
13998 0.429595 WORKSTATION SERVER TCP 50992 > ncp [ACK] Seq=140735
Ack=6579640 Win=64240 Len=0
14004 0.877929 WORKSTATION SERVER TCP 64152 > btrieve [PSH, ACK]
Seq=84281 Ack=158031 Win=62993 Len=151
there are 600ms between the Ok and the beginning of Btrieve messages.


Thanks for your help
Hubert

On 10 mai, 23:21, BtrieveBill <billb... (AT) goldstarsoftware (DOT) com> wrote:

workstation is thinking about what needs to be done next. This may be
quite normal, and 0.6s is a far cry from 30 seconds. Where is the rest
of the time lost?
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive Training - June 2010 in Chicago ***


hbannw wrote:

Hello Bill,

Sorry, I did not explain the right way I think.

in a normal situation, just after logon, there is no delay (1ms)
between these IP frames
the delay becomes longer and longer after several file openings
when I said 30 sec, it was the time its takes to my app to open all
the needed tables

This afternoon, I installed the Client V10 on my WS. It seems to have
the same increasing opening time as the other clients (More tests
follow on the next days, even with Wireshark)

Hubert

On 11 mai, 15:12, BtrieveBill <billb... (AT) goldstarsoftware (DOT) com> wrote:

Hello,

after some more tests with a little programm giving the number of file
opening in 5 seconds, here the results

Workstation : Windows 7, Novell client 2 IR1 all patches

when connected to a novell server (5.1 or OES2) with a PSQL Client
(8.7, 9.5, v10) the number of files opended per seconds decreases
rapidly

when connected with Novell, the test on a Debian Server running 9.5
has the same behavior

When connected to the Debian *without* Novell (but the client still
installed) login the number stays the same even after 10 or 20 tests

Workstation Windows XP Novell client 4.91 Psql 8.7
no problem a all, even after some days connected

on a workstation running PSQL 9.5 workgroup, the test runs ok

so it seems to be the novell client slowing down the connection, I
will continue on that groups.

Does someone have any idea ?

Regards, Hubert