Taking huge time while .loading data from one db to another db table

• vipin_jha123

  Hall of Fame

  Points: 3085

  More actions

  January 9, 2018 at 9:59 am

  #402818

  Hi ,

  I am trying to load one tables data from X database to  Y database in target table .

  I dont understand data count in source is only 25000 , but then also it is unable to load it .
  In my source column 48 column present

  It is getting stucked . below is the screen shot
  

• Jo Pattyn

  SSC-Dedicated

  Points: 32080

  More actions

  January 10, 2018 at 8:58 am

  #1975309

  Trace command on the source why it takes so long? Play with decreasing/increasing buffer sizes