Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 25 Aug 2015 @ 13:13:34 GMT

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

Subj:   Re: Teradata SQLA poor perfromance with version 15.00
From:   Dempsey, Mike

SQL Assistant 15.0 uses a new editor and parser component.

There were issues with the language definition in the original 15.0 release that caused very long parse times for some queries. These were fixed in a later efix. (The entire query is parsed when you first load it) Try downloading the TTU 15.00.04 suite. This contains SQLA

However there is still a memory issue that primarily applies to queries that contain a very large number of statements.

The application contains an 'Import' mode that is intended to be used for performing many inserts to a table so it was not really designed to handle huge numbers of small statements in a single query.

As a result I used a technique that is good for small numbers of statements (and OK for hundreds) but is very bad for tens of thousands.

A customer recently reported similar 'Out of Memory' issues when running a query with 40,000 inserts so I have changed the way I build the result message to avoid this issue.

That fix is not yet available in a TTU suite package. The next package for 15.0 will probably be released in about a month or so.

Note that the most recent available release that still uses the old editor is ( in TTU 14.10.18) if you want to use a newer version that still uses the old editor until the fix is available.)

Mike Dempsey

  <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