Multiple users can query a database table while one user inserts data into that table. Multiple users can update the database concurrently, as long as they are inserting into or deleting from different tables.
When you allow concurrent use of the database during updates, you pay a penalty in performance and disk use. For an explanation of how Sybase IQ handles concurrency issues, see Chapter 10, “Transactions and Versioning”. For other suggestions on improving load performance, see the section “Tuning bulk loading of data”.
