Saw this earlier on today, on the mailing list of the Open Source Development Labs people who are porting their database testing suite from SAP to PostgreSQL.
The comment near the end by Jenny Zhang (one of the porters), saying that "I will put a tar ball on SourceForge today, though the pgsql version performance is not very great." doesn't sound very nifty.
Personally, I don't have the time to analyse why the performance isn't very good and take it forward, so I'm mentioning it here as a heads up in case someone want's something useful to sink their teeth into.
:-)
Regards and best wishes,
Justin Clift
-------- Original Message -------- Subject: Re: [osdldbt-general] DBT1 and dynamic cache Date: 02 Sep 2003 09:46:29 -0700 From: Jenny Zhang <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] References: <[EMAIL PROTECTED]>
Mark is right. DBT1 is designed to be run in several modes: dbdriver + database: each user opens a database connection, and all the transaction go to the database
dbdriver + cache + database: each user opens a database connection, three transactions (bestsellers, newprodicts, and search results by subject) go to the cache, the others go to the database
dbdriver + transaction manager + database: each user opens a connection to the transaction manager, which manages the transaction queue and database connection. All the transaction go to the database.
dbdriver + transaction manager + database + cache: each user opens a connection to the transaction manager, which manages the transaction queue and database connection. Three transactions (bestsellers, newprodicts, and search results by subject) go to the cache, the others go to the database
The pgsql version is available at bk://developer.osdl.org/dbt1.
I will put a tar ball on SourceForge today, though the pgsql version performance is not very great.
Jenny On Tue, 2003-09-02 at 08:42, [EMAIL PROTECTED] wrote:
We do have something that simulates some of the caching effects of web servers. It's under the 'cache' directory. If I remember correctly, it doesn't have to be used, but we do have it working.
Mark
On 31 Aug, Wenguang Wang wrote:
> 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.
>
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ osdldbt-general mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/osdldbt-general
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ osdldbt-general mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/osdldbt-general
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
