General discussion

  • Creator
    Topic
  • #2084748

    SYBASE NT and Unix Operating System

    Locked

    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.

All Comments

  • Author
    Replies
    • #3781983

      SYBASE NT and Unix Operating System

      by erikdr ·

      In reply to SYBASE NT and Unix Operating System

      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,
      / The Netherlands

    • #3769144

      SYBASE NT and Unix Operating System

      by ron navon ·

      In reply to SYBASE NT and Unix Operating System

      This question was closed by the author

Viewing 1 reply thread