0 - 11 of 11 tags for slow

I am trying to replicate the following query, which takes under half a second, in a more dynamic way to expand it's usage:

Hi guys,
The Viewpoint of my inviroment is very slow and I want find another way to monitoring when this kind of problem occurs.
How can I create something like the portlet of "Query monitor" of viewpoint throught DBQL tables or anything else ?
Is there possible ? 

Teradata studio express is very slow on my Mac.  I’ve checked other threads and think I’ve done all the same steps to address it.  

I am trying to use the bulk load method using TDCommandBuilder in C# and also compare it to the individual insert statement performance using the following code. I move data back and forth between SQL Server and Teradata.

Hi All,

I am trying to debug a query which is taking a lot of time.
Following objects are involved in the query :

I've created a Java Function and imported it in TeraData
But after few thousand executions, the function becomes too slow.
You can find below output from TOP command.
tdatuser  23   8  815m  33m 1976 S  200   1.4          1835:21  udfsectsk

I've been having a problem when working with my large SQL files in Teradata Studio. It seems that when the file contains a lot of text, especially when it flows off the screen to the right, the cursor is very slow to react and if you hold the cursor down to move several characters it will jump a few or many characters.

Hi all, 
We are experiencing very slow backup performance through NetBackup - Less than 5MB/Sec on a single stream. 
NetBackup and network configurations are being checked. Can you please advise what we can look at on the Teradata side... Specific Logs etc. Would increasing the response buffer size help at all?


I been testing the FastExport and Fastload Teradata tools and I am finding that data import using fastload is very slow for a particular table.

The process is as follows:

When I call

ResultSet rs = dbmd.getColumns(null, "CUSTDATA", "TRANS", null);

it takes 16 seconds to get an answer back on a fairly unloaded system.  This table has 27 columns.


This seems to be excesvily slow.  Is there anything that can be done to speed this up?


When using BTEQ or SQL Assitant to upload data into tables, I'm only getting about 2 records per second speed. Unfortunately, I don't have access to Fastload. I know its not the network as my down speed is blazing and Oracle is uploading normally.