Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 25 Aug 2015 @ 11:05:11 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Teradata SQLA poor perfromance with version 15.00
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, August 25, 2015 01:51 -->

Hi,

I am wondering if anyone has come across this issue and can help me.

We had a deployment involving around 55000 individual insert statements which runs in around 34 minutes on our production system using SQLA version 13.10, but when run on 15.00 we experience out of memory issues after around 27000 rows.

We noticed that when we drop the file onto SQLA 15.00, that using ctrl-h to replace $env$ with PRD causes SQLA to hang without processinga sungle row. On 13.10 this process takes only around 10 seconds.

I have compared option settings and they both match as far as i can see, so we are having to cancel plans to deploy version 15.00 to our users unless we can find out why.


Cheers



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023