The new version of Upload Tool supports executing multiple database queries in parallel, thus enabling quicker data uploads from your local databases. The new version of upload tool can handle data uploads up to 4 times faster than the previous versions.
The previous versions of Upload Tool will execute the database queries configured in database_sql_queries.xml one at a time, pulling data from your local database and uploading the same into Zoho Reports. In the new version the tool smartly identifies dependencies between the queries configured and looks at parallelizing the execution.
The tool considers the following cases as dependent queries:
Queries trying to upload data into the parent table and the child table concurrently.
Queries that are trying to upload data into the same table.
For the above mentioned cases, queries will be executed sequentially one after the other based on dependency . In all other cases, where there are no dependencies, query execution will be done in parallel, thus enabling faster data uploads.
You can download the latest version of the Upload Tool from here.