Hi everyone,

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])

Reply via email to