What is the difference between compression level 0 1nd 9

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain procedure cache and data cache in sybase.

472


How to start and stop sybase database in linux sap?

478


Differentiate between replication server and sql remote?

473


State some of the products of sybase?

514


Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

471






Explain asa, asa ultralite.

481


Can I partition any table in sybase ?

451


Which should I use, repagent or ltm in sybase?

558


Why place tempdb and log on low numbered devices?

423


What is the difference between replication server and sql remote in sybase?

478


How to start sybase database in windows?

589


How to fix a munged log in sybase?

480


How can set the multipal database ?

2456


How to check sybase database status in linux?

471


Explain table partitioning in sybase.

527