Archives of the TeradataForum
Message Posted: Tue, 25 Aug 2015 @ 13:13:34 GMT
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 220.127.116.11.
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 18.104.22.168 ( in TTU 14.10.18) if you want to use a newer version that still uses the old editor until the fix is available.)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|