To homepage To homepage
Solved

Cdata adapter - CSV File 10(GB)

  • 14 July 2020
  • 3 replies
  • 23 views
R
Rank

We are trying to get a csv file of 10 gb into TimeXtender but it takes very long for TimeXtender to get this loaded and sometimes we are getting an error (system out of memory). Is there a solution or something else we can try to get big csv files into TimeXtener or can we change the CSV file to get it loaded into TimeXtender? We are now using the Cdata adapter and already used the multiple/single file adapter.

 

Thanks for the response!

icon

Best answer by JTreadwell 17 July 2020, 03:50

View original

3 replies

JTreadwell
Rank
Userlevel 3
Badge +5

Hi Rob... A few things to try. 

  1. Make sure SQL Server db is set to Simple Recovery Mode
  2. Decrease the batch Size on the Staging Db
     

     
  3. Also you can set Batch Data Cleansing in Table Settings.
     

     

-Joseph Treadwell
R
Rank

Tried all options but unfortunately no solution.... thanks for the quick response!

JTreadwell
Rank
Userlevel 3
Badge +5

You may also want to try this: 

https://legacysupport.timextender.com/hc/en-us/articles/360022596691-How-to-configure-segmented-table-executions-Chunking-

-Joseph Treadwell

Reply


Terms and ConditionsCookie settings