When possible, SAP Sybase IQ uses multithreading to
improve load performance.
A load/insert will attempt to use all the cores (subject to availability of work to
assign to each core and sufficient resources), as required by the core, to complete
assigned work. The number of cores used during the load/insert at any point in time is
dynamic, depending upon machine workload, available resources, and availability of work
that can be assigned to the core.
A
load runs partially parallel if:
- There are not enough server threads to allocate to the load for full
parallelism, or
- There are not enough threads per connection or per team to allow the load to run
fully parallel, or
- The load is a partial width load where the table has x
columns, but the load specifies fewer than x columns.
When one of the preceding conditions is met, these types of loads should run parallel:
- Binary loads (FORMAT BINARY)
- ASCII fixed width loads
- FORMAT BCP loads
- Loads that include ROW DELIMITED BY and DELIMITED BY with FORMAT ASCII, FORMAT
BINARY or FORMAT BCP