Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Sybase
  2. Suggest New Category

What is the difference between compression level 0 1nd 9

Question Posted / shweta.v

Answers were Sorted based on User's Feedback



What is the difference between compression level 0 1nd 9..

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

What is the difference between compression level 0 1nd 9..

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

Post New Answer

More Sybase Interview Questions

When you change a database option when will it come into effect?

0 Answers  

How can I tell the datetime my server started?

0 Answers  

What is server replication?

0 Answers  

List the types of locking?

0 Answers  

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

0 Answers  

When are stored procedures compiled in sybase?

0 Answers  

You need to remove duplicate rows from a sybase table. How would you do that?

0 Answers  

How can I execute dynamic sql with ase in sybase?

0 Answers  

How do I take advantage of table partitioning with bcp in sybase?

0 Answers  

how to do application monitoring through AutoSys?

3 Answers   Cognizant,

What does –i option do in sybase tools?

0 Answers  

Is data insertion is fast in SYBASE IQ if we have more indexes on a table?

3 Answers   FIC,

For more Sybase Interview Questions Click Here
Categories