Paul's Programming Notes PostsRSSGithub

Compress - Sybase ODBC

Sybase has a odbc parameter called “Compress” that is disabled by default. It’s very useful if you’re running queries on something with slow network transfer speeds and large datasets.

Example:

Compress = yes

This improve the performance of my query by about 40%.