Archives of the TeradataForum
Message Posted: Fri, 24 Jan 2003 @ 00:07:39 GMT
An .EXPORT DATA was used to perform the BTEQ Tests.
The ODBC connections were configured with 65477 Response Buffer Size, the OLE DB connections had the extended properties setup with the Maximum Response Buffer Size and the CLISPB.DAT file was modified to ensure the CLI connections used the Maximum Response Buffer Size.
When I did the original FastExport investigation, I performed the tests on a Dual CPU, Windows 2000 Server, connected via 100Mb LAN connection into the same Switch as the Teradata Nodes. CPU usage never went above 15% during the tests. The tests were performed using the 6.1 Teradata Utilites. I have considered rerunning the tests again with the latest release, but have decided not to, until we move to V2R5 and 7.0 Teradata Utilities.
I could raise it as a problem, except the performance with 1 session is good and well above what we would expect.
Does any other company use the Windows version of FastExport and have you experienced this same issue?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|