Restricting Database Access

Schedule updates when demand is low for better query performance.

For better query performance, set the database to read-only, if possible, or schedule significant updates for low usage hours. Sybase IQ allows multiple query users to read from a table while you are inserting or deleting from that table. However, performance can degrade during concurrent updates to the database.

Related concepts
Managing Disk Space in Multiplex Databases
Load Balancing Among Query Servers
Disk Caching