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 |
Is sybase free?
Is data insertion is fast in SYBASE IQ if we have more indexes on a table?
Why not max out all my columns sybase?
Is there any advantage of last_name varchar(50) over this last_name varchar(255)?
What is isql in sybase?
Explain coalesce.
What is the difference between compression level 0 1nd 9
List different types of locks in sybase?
Explain about the mainframe connect tools from sybase?
How to start and stop sybase database in linux sap?
What are the operating systems in which sybase could take its presence?
How do I choose which tables to partition in sybase?
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)