Much time taken in SQl assitant when compared with DBQlog table time

Tools & Utilities
Teradata Employee

Much time taken in SQl assitant when compared with DBQlog table time

Hello

When i run a query its taking 2 min trough a java app we developed -- 1.30 in Sql assistant to display rec..But intrestingly its just 60 millisec when we check in DBQLOG time

Any idea why this huge difference is coming???

Thanks

Aravind

2 REPLIES
Enthusiast

Re: Much time taken in SQl assitant when compared with DBQlog table time

DBQLOG is showing time the Teradata server took to process the request, Whil the time shown in application and SQL Assistant includes the time of data transfer over ODBC OR JDBC over the network. I think that is causing the time difference between these measurements. 

Khurram
Teradata Employee

Re: Much time taken in SQl assitant when compared with DBQlog table time

Thanks Khurram,,I guessed it,,,But will it be such so huge difference

Thanks

Aravind