Solved

Sybase XI for NT and IPX/SPX slow response

Posted on 1997-11-18
3
325 Views
Last Modified: 2011-09-20
I'll start by saying that I don't know if this is a Sybase question or an NT question.  The problem we are having is that response from the Sybase database is extremely slow when using the IPX/SPX protocol over a Novell 4.11 network.  Using IP is not an option because all of the workstation accessing the database are 486 SLC2 machines running Windows 3.11 and have 16 MB RAM.  Is there anything we can do to speed up the response time?
0
Comment
Question by:mwalter
  • 2
3 Comments
 

Author Comment

by:mwalter
ID: 1098091
Edited text of question
0
 

Accepted Solution

by:
umurasx earned 200 total points
ID: 1098092
As of I know there is no solution to this problem. We can say it is the drawback of IPX/SPX protocol. What's happening is that when we have IPX/SPX protocol in the network, it internally calls SAP (Simple Advertising Protocol) to check whether the connection between the server and  client is active or not, which happens very frequently; and this is the reason why it is recommended in Wide Area Network. It unnecssarily increases the Network traffic. If you remember this mechanism which is used in Novell Watch dog, to kill the stations which are not active. If you have Windows 95 client, we can avoid this from the client side. But this will not give you a major difference in performance, still you can feel it.
0
 

Author Comment

by:mwalter
ID: 1098093
Do you know of any way of "tweaking" the IPX/SPX settings in NT to improve the performance?
0

Featured Post

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SYBASE ASE HA Configuration 8 396
SQL Syntax Select Top in each group 2 188
SSIS - Update a Sybase Table 33 163
set dsync and directio options according to device type 4 43
This tutorial shows how to create a greeting card by combining two image layers and a text layer on a PC using a free image editing app.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question