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...

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.

Using large raw partitions with replication server on unix in sybase?

0 Answers  

---

What is cmaxpktsz good for in sybase?

0 Answers  

---

Does table partitioning require user-defined segments in sybase?

0 Answers  

---

How do I correct time slice -201?

0 Answers  

---

Explain index covering?

0 Answers  

---

---

What causes re-resolution of a stored procedure in sybase?

0 Answers  

---

Differentiate between db-lib and ct-lib?

0 Answers  

---

In sybase, we can have multiple users associated to same login ,each corresponds to different databases, right? how can we login to one database with corresponding user id?

3 Answers   ISRO,

---

Differentiate between clustered and non-clustered index.

0 Answers  

---

What do you mean by deferred update in sybase?

0 Answers  

---

Must I use multiple devices to take advantage of partitions in sybase?

0 Answers  

---

How to connect sybase database from python?

0 Answers  

---