Discussion Locked

SYBASE NT and Unix Operating System

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by stefan.giuros

Dear Sir: It is very difficult to see a solution to your problem, because i have no hint if the two databases are identical in every aspect (indexes, segments, devices, server configure parameters, hardware and so on). If all queries on Unix are faster than on NT, except the one mentioned, I think the problem lies in the way tables are placed on your devices, or maybe you use flat files for devices in Unix rather than raw devices.
Sincerely, yours
Stefan Giuros

This discussion is closed to new replies.