Archives of the TeradataForum

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

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

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 15.0.0.5.

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 14.10.0.10 ( 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>>