[osdldbt-general] DBT1 and dynamic cache

[Wenguang W. <Wen...@us...>]

Hi, dbt1 designers and developers,

I like the idea of eliminating the web servers in dbt1 to focus on the 
performance of DBMS. However, I have a question about whether the 
current dbt1 can really represent e-commerce workloads.

TPC-W encourages the use of web caches to reduce the load on DBMS. Since 
web caches are not used in dbt1, all cachable queries have to be 
procesed by the DBMS in dbt1. This could increase the load to the 
backend DBMS by several times at least. These queries make dbt1 more 
like a TPC-H throughput test instead of an e-commerce test. Is this 
design of dbt1 intentional or is it planned to be fixed later?

Thanks.

-- 
Wenguang Wang

PhD Candidate
Dept. of Computer Science        Phone: (306) 966-1947
University of Saskatchewan       Fax  : (306) 966-4884
1C101 Engineering Building       Email: wa...@cs...
57 Campus Drive                  Web: http://www.cs.usask.ca/~wew036
Saskatoon, SK S7N 5A9
Canada