Here are some recommendations on how to improve your data exporting performance, i.e. export data faster and more reliable.

There is a separate topic about exporting very large data sets. If that's not your case, please read below.

Preparing the Databases

When registering your databases, use FD engine if it supports your database type (available in Exportizer Enterprise). FD has some useful data options which allows flexible export configuration and sometimes speed up the exporting.

Preparing the Source Datasets

First, try to use the SQL query tool whenever possible (available in Exportizer Pro and Exportizer Enterprise). Yes, if you need to export a full table, it is more convenient to click it in the table list and then export. But if you need to add some data filters, then SQL code does it much more effectively. If you are new to SQL, try to start from this very simple query:

SELECT * FROM <table_name>
WHERE <column_name1> = ... AND <column_name2> = ...

Here, <table_name> is the name of the table to export data from, and <column_name1> and <column_name2> are the names of columns in the table.

Second, if the source database is a remote database and the dataset is not very large, fetch all records before exporting (e.g., by clicking the Last Record button). The fetched records are allocated in your local operating memory, so the exporting process will not interact with the server and will perform much faster.

Third, if the source database uses FD interface, try different values of Fetch size environment option to find the optimal performance.

Configuring the Data Exporting

In Export dialog, there are lot of options. Most of them concern the output format, but some of them can affect the export speed.

So please consider the following: