Optimizing Performance
Topics:

The run-time performance of DataMigrator depends on many factors: host platform, network protocol, I/O devices, type of SQL command, and selected DBMS. Depending on your environment, one or more of these factors may be in your control. The following topics outline the options that have the greatest impact on performance.

The issues described here may or may not affect your particular configuration. After careful review and comparison, you may determine that your request will need a lot of internal processing and significant I/O. This may be fine if your nightly incremental updates are low in volume or if you are on a processor where disk access is not a bottleneck. However, if you have only one hour to process your data and the server is on a small machine with few resources, an alternate approach may be necessary.

In either case, review these performance considerations, and compare them to your environment. For most applications, the default functionality of DataMigrator is sufficient for your data management needs. If the performance objectives cannot be met, these guidelines can at least provide you with some insight into the location of potential bottlenecks and possible strategies to overcome them.


iWay Software