Data Affinity

Data affinity accesses cached data to boost query performance in multiplex servers.

For optimum scale-out performance, Sybase recommends that you have 4-8 multiplex nodes with total memory across the cluster that can hold most of the working set data for the queries. Affinity is automatically enabled for multiplex databases. No user intervention or maintenance is required.