General discussion

Locked

SYBASE NT and Unix Operating System

By Ron Navon ·
Dear Sir,

I am running an application based on SYBASE 11.5 on Unix and Widows NT 4.0.

Most of the activity of Data Base as any Data Base is Merge, Select and Update.

I tested this application, when I am doing a select commandfrom merge of 11 tables and display the result on screen, I found a very strange result that I give the result in NT faster than Unix.

I will be very appreciate if any one assist me to solve this problem.

Thanks and Best Regards.


Sincerely Yours,
Ron

P.S.: You can send your anwser to e-mail bpeleg@mekorot.co.il also.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SYBASE NT and Unix Operating System

by erikdr In reply to SYBASE NT and Unix Operat ...

Why exactly are you sure that the result is 'very strange'? I presume your Unix machine has more MIPS horsepower than the NT one, but there are more factors in place:
* Quality and tuning of the two Sybase implementations (ask Sybase for details, e.g. compare Sybase-Linux or Sybase-SCO with Sybase-NT on exactly the same Intel machine)
* Tuning of Unix and NT
* Sizes of the databases, are they really the same
* Connection from client to server, is the LAN nowhere a bottleneck?

As an example: 3 years back we compared DB2/400 on an AS/400 monster with DB2/NT on a humble Intel. With same database size, the NT box outperformed with 50% because SQL implementation on AS/400 was quite lousy.
Have fun,
<Erik> / The Netherlands

Collapse -

SYBASE NT and Unix Operating System

by Ron Navon In reply to SYBASE NT and Unix Operat ...

Poster rated this answer

Collapse -

SYBASE NT and Unix Operating System

by Ron Navon In reply to SYBASE NT and Unix Operat ...

This question was closed by the author

Back to Networks Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums