Clarion - slow tps on NetWare

Author

slow tps on NetWare

scott.cornell@gmail.com

2005-07-26, 8:59 am

Let me first start by saying I know little to nothing about Clarion
databases. However, I have been asked to look into a performance issue
at one of our remote locations that apparantly has an outside developed
clarion application using TPS files. The database is stored on a
NetWare server and performance is horrible!!! I've duplicated the
issue here at my office and have tested it on NetWare 5.1 and 6.5 (both
tradition and NSS) and perf is horrible. It runs fine on a Window 2003
server and fine as well on a Linux/Samba share. I've also removed
client/32 from the picture and just ran the MS client for NetWare which
didn't change the performance issues. I've changed numerous settings
on the NetWare server (Oplocks, sig levels, etc....). I've ran
numerous packet traces and basically, when I run my test, it floods the
network with the following three requests: (btw, the retransmission is
some kind of bug with Ethereal as they're really not there). Also,
I've seen other threads on this board regarding re-compiling to MySql,
but I don't know how large of a task this would be.

Anyway, any ideas or help would be greatly appreciated!!!!

C Clear Physical Record[Unreassembled Packet]
C Log Physical Record[Unreassembled Packet]
C Read From A File[Unreassembled Packet]

73300 6.922571 10.1.1.15 10.1.3.224 NCP
R OK
73301 6.922575 10.1.1.15 10.1.3.224 NCP
[TCP
Retransmission] R OK
73302 6.922993 10.1.3.224 10.1.1.15 NCP
C
Clear Physical Record[Unreassembled Packet]
73303 6.922995 10.1.3.224 10.1.1.15 NCP
[TCP
Retransmission] C Clear Physical Record[Unreassembled Packet]
73304 6.923026 10.1.1.15 10.1.3.224 NCP
R OK
73305 6.923030 10.1.1.15 10.1.3.224 NCP
[TCP
Retransmission] R OK
73306 6.923287 10.1.3.224 10.1.1.15 NCP
C
Log Physical Record[Unreassembled Packet]
73307 6.923290 10.1.3.224 10.1.1.15 NCP
[TCP
Retransmission] C Log Physical Record[Unreassembled Packet]
73308 6.923321 10.1.1.15 10.1.3.224 NCP
R OK
73309 6.923325 10.1.1.15 10.1.3.224 NCP
[TCP
Retransmission] R OK
73310 6.923570 10.1.3.224 10.1.1.15 NCP
C
Read From A File[Unreassembled Packet]
73311 6.923572 10.1.3.224 10.1.1.15 NCP
TCP
Retransmission] C Clear Physical Record[Unreassembled Packet]

Earl R Coker

2005-07-26, 8:59 am

Hi Scott,

You will get more answers faster on the news.softvelocity.com newsgrout
since more Clarion Developers use that newsgroup. Sorry, I don't have any
suggestions for you. Yours is the first complaint I have ever heard about
with respect to NetWare and all of the Clarion Developers that use NetWare
seem to say Clarion apps run faster on it.

--
Best Regards,
Earl R Coker
ksasales AT machlink DOT com
kwiksys AT kwiksystems DOT net
www.kwiksystems.net
www.kwiksystems.com
www.kwiksystems.net/appshell/index.htm
www.kwiksystems.com/clarion.htm (BigTamer(tm) Templates)

<scott.cornell@gmail.com> wrote in message
news:1122382849.749571.192300@g14g2000cwa.googlegroups.com...
: Let me first start by saying I know little to nothing about Clarion
: databases. However, I have been asked to look into a performance issue
: at one of our remote locations that apparantly has an outside developed
: clarion application using TPS files. The database is stored on a
: NetWare server and performance is horrible!!! I've duplicated the
: issue here at my office and have tested it on NetWare 5.1 and 6.5 (both
: tradition and NSS) and perf is horrible. It runs fine on a Window 2003
: server and fine as well on a Linux/Samba share. I've also removed
: client/32 from the picture and just ran the MS client for NetWare which
: didn't change the performance issues. I've changed numerous settings
: on the NetWare server (Oplocks, sig levels, etc....). I've ran
: numerous packet traces and basically, when I run my test, it floods the
: network with the following three requests: (btw, the retransmission is
: some kind of bug with Ethereal as they're really not there). Also,
: I've seen other threads on this board regarding re-compiling to MySql,
: but I don't know how large of a task this would be.
:
: Anyway, any ideas or help would be greatly appreciated!!!!
:
: C Clear Physical Record[Unreassembled Packet]
: C Log Physical Record[Unreassembled Packet]
: C Read From A File[Unreassembled Packet]
:
:
: 73300 6.922571 10.1.1.15 10.1.3.224 NCP
: R OK
: 73301 6.922575 10.1.1.15 10.1.3.224 NCP
: [TCP
: Retransmission] R OK
: 73302 6.922993 10.1.3.224 10.1.1.15 NCP
: C
: Clear Physical Record[Unreassembled Packet]
: 73303 6.922995 10.1.3.224 10.1.1.15 NCP
: [TCP
: Retransmission] C Clear Physical Record[Unreassembled Packet]
: 73304 6.923026 10.1.1.15 10.1.3.224 NCP
: R OK
: 73305 6.923030 10.1.1.15 10.1.3.224 NCP
: [TCP
: Retransmission] R OK
: 73306 6.923287 10.1.3.224 10.1.1.15 NCP
: C
: Log Physical Record[Unreassembled Packet]
: 73307 6.923290 10.1.3.224 10.1.1.15 NCP
: [TCP
: Retransmission] C Log Physical Record[Unreassembled Packet]
: 73308 6.923321 10.1.1.15 10.1.3.224 NCP
: R OK
: 73309 6.923325 10.1.1.15 10.1.3.224 NCP
: [TCP
: Retransmission] R OK
: 73310 6.923570 10.1.3.224 10.1.1.15 NCP
: C
: Read From A File[Unreassembled Packet]
: 73311 6.923572 10.1.3.224 10.1.1.15 NCP
: TCP
: Retransmission] C Clear Physical Record[Unreassembled Packet]
:

scott.cornell@gmail.com

2005-07-27, 8:59 am

Thanks very much for the quick response and I will post the same
message in the other ng you mentioned. That's what I've read as well
(faster on NetWare), which is our experience with the other
applications, but it certainly isn't true with this Clarion app.

Sponsored Links