What is the difference between compression level 0 1nd 9
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 |
What sybase central?
Why not max out all my columns sybase?
How do I force an index to be used in sybase?
What is trace flag definitions in sybase?
Why place tempdb and log on low numbered devices?
How do I configure the burn factor in sybase?
How can i retrieve the pseudoColumn values of a table in sybase? In oracle, we can get the same as 'ROWID'. Likewise in sybase which one is pseudo column?
The secondary truncation point is on. How would you clear the logsegment?
You need to multiply all values of a single column. How would you do that?
what is the difference between dbcc checkstorage and other dbcc commands
How do I start sybase control center in windows?
Explain the difference between numeric and decimal data types 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)