# Suggestions in how to load tables over 15 millions rows using CData Sync

**URL:** <https://community.cdata.com/t/suggestions-in-how-to-load-tables-over-15-millions-rows-using-cdata-sync/970>\
**Category:** CData Sync\
**Tags:** large-dataset, large-table, question, servicenow, cdata-sync, sql-server\
**Created:** [December 13, 2024, 1:20am UTC](https://community.cdata.com/t/suggestions-in-how-to-load-tables-over-15-millions-rows-using-cdata-sync/970 "2024-12-13T01:20:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![marodsal](https://avatars.discourse-cdn.com/v4/letter/m/d07c76/32.png) [@marodsal](https://community.cdata.com/u/marodsal)\
**Post date:** [December 13, 2024, 1:20am UTC](https://community.cdata.com/t/suggestions-in-how-to-load-tables-over-15-millions-rows-using-cdata-sync/970/1 "2024-12-13T01:20:56Z")

</div>

What are the suggestion in how to load tables over 15 millions rows using CData Sync? The data source is ServiceNow and the destination is SQL Server. I changed the sync.exe.config to

**\<?xml version=“1.0” encoding=“utf-8” ?\>  
\<configuration\>  
&nbsp; \<startup\>  
&nbsp; &nbsp; \<supportedRuntime version=“v4.0” /\>&nbsp;  
&nbsp; \</startup\>  
&nbsp; \<!-- You can add some Java JVM parameters here. This is for Java application only.&nbsp;  
&nbsp; \<appSettings\>  
&nbsp; &nbsp; \<add key=“JAVA\_OPTS” value=“” /\>  
&nbsp; \</appSettings\>  
&nbsp; --\>  
\<appSettings\>&nbsp;  
&nbsp; &nbsp; \<add key=“JAVA\_OPTS” value=“-Xms2g -Xmx50g”/\>&nbsp;  
\</appSettings\> &nbsp;  
&nbsp;&nbsp;  
\</configuration\>**

Also, I changed the timeout of the jobs to 6200.

---

<div class="post-metadata">

**Author:** ![marodsal](https://avatars.discourse-cdn.com/v4/letter/m/d07c76/32.png) [@marodsal](https://community.cdata.com/u/marodsal)\
**Post date:** [December 18, 2024, 11:56am UTC](https://community.cdata.com/t/suggestions-in-how-to-load-tables-over-15-millions-rows-using-cdata-sync/970/2 "2024-12-18T11:56:55Z")

</div>

I found a solution or workaround.

1. DBA changed the SQL to simple mode for the first loading of the largest tables.
2. I added this line &nbsp; **\<add key=“JAVA\_OPTS” value=“-Xms2g -Xmx25g”/\>** to the **sync.exe.config** file.
3. In the Jobs task, I changed the **Command Timeout** to **6200**.

I was able to load the two tables over 18 million of rows without any issue after those changes.