When you design the market data schema, Sybase recommends thatyou use:
- Round-robin partitioning to partition the database table that stores the market data, because the RAPCache subscriber can load data concurrently into multiple partitions.
- A small number of indexes for the table storing market data, because a large number of indexes adversely affects message-load performance.
See
Adaptive Server Enterprise Performance and Tuning Series: Basics for additional information on performance-related database and schema design principles.