Sybase recommends that, while you are designing the market data schema, you:
- 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.
- Have 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-centric database abd schema design principles.