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 |
How do I pipe the output of isql to a file in sybase?
How do you view log files in sybase?
How would you replicate col = col + 1 in sybase?
What is sybase used for?
Explain about the mainframe connect tools from sybase?
What is the relationship between jdbc and sybase?
What is the use 'return' keyword in Stored Procedure?
What is the difference in storage type of numeric and decimal data types in sybase ?
How to swap a db device with another?
Why place tempdb and log on low numbered devices?
What command helps you to know the process running on this port, but only su can run this command?
How can we add a column to a table without altering the same?
Oracle (3253)
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)