Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 03 Nov 2002 @ 13:51:52 GMT


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


Subj:   Re: Does Teradata have anything similar to Procedural caching (supported with SQL Server)
 
From:   Bhupesh Singu

This is a straight SQL and yes, i collected statistics on the tables and columns.We conducted the test via two methods.

Method 1: Run the query via queryman and calculate the DBMS time from queryman. Repeated the queries.

The same query was run from SQL Server Query Analyzer (with return result set turned off) and the execution times captured via profiler. The queries were repeated

Method 2: Created C# script that takes DSN, Database Name, Query, Threads, Loops as inputs and outputs the time to return first row of output and the last row of output. We ran this program against Teradata and SQL Server from two different client computers. And we got similar results.

The execution time results indicate better number for SQL Server.Does anyone see any obvious mistake in my tests? Or did I miss something.


Thanks

Bhupesh Singu
Database Administrator
Information Technology Department
State of Iowa



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023