Archives of the TeradataForum
Message Posted: Thu, 27 Aug 2015 @ 15:55:07 GMT
I don't know if there were changes in ICU, TeraGSS or ODBC that might have a performance impact, but there shouldn't be any that would cause such a large impact.
Have they made any changes to the table? New indexes, Join Index, other changes?
If they are using ODBC ask them to try Teradata.Net instead. This is always the recommended connection method... and it is usually faster.
I ran some tests myself.
These only load 1000 rows (34 mostly Varchar columns) Note that since I connect over a VPN to a Teradata system 2000 miles away my times will be larger than for someone connecting over a local network. (This extra communication time may mask some performance issues - but not 6x issues)
Version Connection Insert Time / Mode (Seconds) 22.214.171.124 ODBC 266 126.96.36.199 ODBC 285 188.8.131.52 Teradata.Net 186 184.108.40.206 Teradata.Net 175 220.127.116.11 Teradata.Net 174 18.104.22.168 Teradata.Net 160 * Not yet available Teradata Studio JDBC 495 Execute Parallel Teradata.Net 15 Import Teradata.Net 2
So I do see a small increase in time from 13.10 to 14.10 but this is more than offset if you switch to Teradata.Net instead of ODBC. (And using Import totally blows away the use of individual Insert statements.) It also appears that the 15.x versions are faster than either 13.10 or 14.0.
If the customer is still having issues they will need to open an incident with GSC so that their specific issue can be looked into.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|