Answers were Sorted based on User's Feedback
1.directio performs IO in the same manner as raw devices
and provides the same performance benefit as raw devices,
but has the ease of use and manageability of file system
2.directio is a static parameter that requires a restart of
Adaptive Server to take effect.
|Is This Answer Correct ?||4 Yes||0 No|
Answer / atish
directio is clause of disk init command, introduced in
ASE15, for file system devices.It allows to configure ASE to
transfer data directly to disk bypassing the O.S. buffer
cache.It can be set during device initialization.It mainly
removes read dependency.
|Is This Answer Correct ?||3 Yes||0 No|
What are the catches?
what is directio?
You need to remove the affected rows and dashes. How would you do that?
Explain index covering?
Is sybase sql?
Is sybase open source?
What is replication server? What is its role in sybase?
How to divide by zero and nulls in sybase?
Is data insertion is fast in SYBASE IQ if we have more indexes on a table?
How to view the log files in sybase?
Can I run any transact-sql command on a partitioned table in sybase?
What is rollback trigger in a trigger?