What is the difference between compression level 0 1nd 9
- 2 Answers
- 6319 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dataarchitect
1. Compression levels are used during either full or log
backups.
2. O is lowest compression level while 9 is highest
compression level
3. Just keep in mind while deciding about compression level
higher compression level will cause max. cpu utilization
and may affect performanc of syste, especially for big db.
4. ASE 15** comes up with new compression levels i.e. 100
and 101 . sybase claims that these are fastes and use less
cpu...
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / dilip voora
Compression level 0 indicates no compression and 9 indicates the highest level of compression. From ASE 15.x two more compression levels 100 and 101 are added. Compression level 100 provides faster compression where as the compression level 101 indicates better compression. 100 and 101 will not create much load on CPU.
| Is This Answer Correct ? | 1 Yes | 0 No |
How do I turn off marked suspect on my database in sybase?
How do I open a sybase database?
Is there any advantage of last_name varchar(50) over this last_name varchar(255)?
how to do application monitoring through AutoSys?
Explain locking. List its types.
Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
What do you mean by asa in sybase?
What are the important features of sybase?
Explain autosys. Why do you need it.
How do I configure identities in sybase?
How does partition assignment relate to transactions in sybase?
Compare in and exists?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
