# Connx Sync taking longer than expected **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Adabas, Natural, CONNX\ **Created:** [May 21, 2024, 8:18pm UTC](https://techcommunity.softwareag.com/t/connx-sync-taking-longer-than-expected/296016 "2024-05-21T20:18:38Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![manojn](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@manojn](https://techcommunity.softwareag.com/u/manojn)\ **Post date:** [May 21, 2024, 8:18pm UTC](https://techcommunity.softwareag.com/t/connx-sync-taking-longer-than-expected/296016/1 "2024-05-21T20:18:38Z")
#### _ **Product/components** used and **version/fix** level:_ ConnX version 14.8 #### _Detailed explanation of the problem:_ when perform a sync of table from testDatabase ( Source Enterprise OLEDB/ODBC Adapter to Target SQL Server), which contains 9000 rows, it takes more than 20 mins (on an average). #### _Error messages / **full error** message screenshot / **log** file:_ below is snipped of connx web interface DatSync \> ‘Historocal Syncs’ tab ![image](https://global.discourse-cdn.com/techcommunity/original/3X/9/9/9974d5cf7534baefcc7c54cbbee99b1c9b012310.png) #### _Question related to a **free trial** , or to a **production (customer)** instance?_ What are the factors effecting duration of sync? How can I improve the sync duration? ---
**Author:** ![anon27083125](https://avatars.discourse-cdn.com/v4/letter/a/c2a13f/32.png) [@anon27083125](https://techcommunity.softwareag.com/u/anon27083125)\ **Post date:** [May 21, 2024, 8:57pm UTC](https://techcommunity.softwareag.com/t/connx-sync-taking-longer-than-expected/296016/2 "2024-05-21T20:57:33Z")
The slow performance may be due to the source ODBC driver for IDMS. Could you please use Infonaut, and issue a “SELECT \* FROM ” for the table in question, and report how long it takes to return the 9000 rows. This will give us a baseline of how quickly IDMS returns the data to CONNX. ---
**Author:** ![manojn](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@manojn](https://techcommunity.softwareag.com/u/manojn)\ **Post date:** [May 22, 2024, 9:26pm UTC](https://techcommunity.softwareag.com/t/connx-sync-taking-longer-than-expected/296016/3 "2024-05-22T21:26:54Z")
Hello Larry, Run a **query on InfoNaut**. query: Select \* from {database}.dbo.{table} Records 1 of 9017 || Records/Sec : 59 || Time : 152.3484526 - it took 2-3 mins to view all the rows in that tables - the table contains 9017 rows - in the above message the sync that shows 9016 is the same table as here Run a **DataSync using transformations**. Transformation Name || Target Table || Start || End || Rows || Inserted || Updated || Deleted || Sync Type || Status Code NewTransformation || SQLServerTable|| 5/22/2024 8:22:12 AM || 5/22/2024 8:22:17 AM || 0 || 0 || 0 || 0 || Full (NoCRC) || Success - No new transformation just load the all the columns to a new custom column. - Not sure why Rows, Inserted, Updated, Deleted are 0. - time taken in only 5 secs - And I can see all the 9016 rows on the newly create SQLserverTable Run a **DataSync Tables**. Item Name || Catalog || Owner || Start || End || Rows || Inserted || Updated || Deleted || Sync Type || Status Code TableName || MainframeDatabase || dbo || 5/22/2024 8:23:10 AM || 5/22/2024 8:25:45 AM || 9017 || 0 || 0 || 0 || Full || Success - it took 2-3 mins to complete the sync to [mainframeDatabase].[TableName] - [mainframeDatabase].[TableName] Already exsisting from previous syncs On InfoNaut it says 9017 rows are available to view On a newly created Transformation to a new table. select count(\*) from [dbo].[SQLServerTable] - 9016 rows On sync table select count(\*) from [mainframeDatabase].[TableName] - 9017 rows - Running Sync on server took 2-3 mins to complete sync (Full Reload) to SQLServer ---
**Author:** ![anon27083125](https://avatars.discourse-cdn.com/v4/letter/a/c2a13f/32.png) [@anon27083125](https://techcommunity.softwareag.com/u/anon27083125)\ **Post date:** [May 22, 2024, 10:38pm UTC](https://techcommunity.softwareag.com/t/connx-sync-taking-longer-than-expected/296016/4 "2024-05-22T22:38:13Z")
II notice that these times are much different than what was originally reported - were you syncing this table in a group when you had the slower times? ---
**Author:** ![manojn](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@manojn](https://techcommunity.softwareag.com/u/manojn)\ **Post date:** [May 23, 2024, 2:03pm UTC](https://techcommunity.softwareag.com/t/connx-sync-taking-longer-than-expected/296016/5 "2024-05-23T14:03:54Z")
No, we want to sync all the tables in a group, but we are syncing one table at a time. I just ran a sync of 1 table from tables tabs (/datasync/tables) and took 20 mins to complete the Sync ``` 2024-05-23 08:42:45 AM 00:20:24 9017 0 0 0 ``` ---
**Author:** ![anon27083125](https://avatars.discourse-cdn.com/v4/letter/a/c2a13f/32.png) [@anon27083125](https://techcommunity.softwareag.com/u/anon27083125)\ **Post date:** [May 23, 2024, 2:18pm UTC](https://techcommunity.softwareag.com/t/connx-sync-taking-longer-than-expected/296016/6 "2024-05-23T14:18:15Z")
In your prior message you stated that the sync took 2-3 minutes, and now you are stating it takes 20 minutes. Is my understanding correct? ---
**Author:** ![manojn](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@manojn](https://techcommunity.softwareag.com/u/manojn)\ **Post date:** [May 23, 2024, 6:37pm UTC](https://techcommunity.softwareag.com/t/connx-sync-taking-longer-than-expected/296016/7 "2024-05-23T18:37:25Z")
There are 2 places I performed sync and posted results 1. from connx server machine using connx dataSync classic application 2. using connx web interface, run from developer machine, using port {ip-address-of connx server}:9500 The issue is with running sync on web interface. “Could you please use Infonaut, and issue a “SELECT \* FROM ” for the table in question, and report how long it takes to return the 9000 rows” - - this task I performed from connx installed server machine, along with sync steps also, which I posted [Connx Sync taking longer than expected - #3 by manojn](https://techcommunity.softwareag.com/t/connx-sync-taking-longer-than-expected/296016/3) from connx application running from server, using connx datasync classic application -32bit, it took only 2-3 mins (as i am unable to share snippet from the connx installed machine, I noted down the numbers) "II notice that these times are much different than what was originally reported " - - the initially reported numbers are issue from connx web interface. but when running the sync from connx web interface, https:/{ip address of the server}:9500/ , it took 20 mins. (snippet took from developer machine, using connx web interface) ---
**Author:** ![anon27083125](https://avatars.discourse-cdn.com/v4/letter/a/c2a13f/32.png) [@anon27083125](https://techcommunity.softwareag.com/u/anon27083125)\ **Post date:** [May 23, 2024, 8:11pm UTC](https://techcommunity.softwareag.com/t/connx-sync-taking-longer-than-expected/296016/8 "2024-05-23T20:11:43Z")
Thank you for providing this additional detail. With this information, it will be necessary for you to create a support incident so this issue can be researched further. The performance of the web interface should be identical to that of the classic interface. ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [November 19, 2024, 8:11pm UTC](https://techcommunity.softwareag.com/t/connx-sync-taking-longer-than-expected/296016/9 "2024-11-19T20:11:49Z")
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.