Database Reference
In-Depth Information
Eliminating the source bottleneck
There are various ways in which you can optimize the source. They are discussed as fol-
lows.
Increasing the network packet size
As discussed in the
Eliminating the target bottleneck
section, increasing the network packet
size of the table will allow a greater volume of data to pass through the network at a partic-
ular instance.
These properties can be enhanced by the database administrator. Consult your database ad-
min team to increase the network packet size.
Optimizing the database query
When you read the data from the database table, Integration Service generates a query to
extract the data from the table. You can fine-tune the query to extract only the required
data. If you extract all the data and then add a Filter or other transformations, it will hamper
the performance.
You can tune the query to extract only the required data, which will save time and help in
performance enhancement. This is called a SQL override.
These were the various ways in which you can find and eliminate the source bottleneck. In
the next section, we will talk about the mapping and transformation bottlenecks.
