what is directio?
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
devices.
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 does –i option do in sybase tools?
What is the difference in storage type of numeric and decimal data types in sybase ?
How would you fix a munged log in sybase ?
How to start and stop sybase database in linux sap?
When are stored procedures compiled in sybase?
How can I execute dynamic sql with ase in sybase?
Tempdb is full. How would you clear it?
What is cmaxpktsz good for in sybase?
What is server replication?
What is the maximum nesting level of Stored Procedure and Triggers in Sybase?
How configure sybase odbc connection?
Why do my page locks not get escalated to a table lock after 200 locks?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)