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 |
Must I use multiple devices to take advantage of partitions in sybase?
Why am I running out of locks on the replicate side in sybase ?
What do you mean by asa in sybase?
What is open client in sybase?
How do you troubleshoot if your tempdb gets filled
How do I choose which tables to partition in sybase?
How configure sybase odbc connection?
What is my identity burn factor vulnerability right now in sybase?
Using large raw partitions with replication server on unix in sybase?
How can I tell the datetime my server started?
How can I improve throughput in sybase?
Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?
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)