Re: Possible Commit Syntax Change for Improved TPS

2003-10-02 Thread Jeremy Zawodny
On Tue, Sep 30, 2003 at 09:36:46PM +0100, Seun Osewa wrote: > Hi Jeremy, > > Hmmm ... I guess the meat of my suggestion is that it be made > available on a per-transaction basis because in many applications > some transactions are more "critical" than others. So even on > systems where there are

Re: Possible Commit Syntax Change for Improved TPS

2003-09-30 Thread Seun Osewa
- Original message ---  From: Jeremy Zawodny <[EMAIL PROTECTED]>  Date: Tue, 30 Sep 2003 10:17:04 -0700  Subject: Re: Possible Commit Syntax Change for Improved TPS  On Tue, Sep 30, 2003 at 01:19:19PM +0100, Oluwaseun Osewa wrote: > Hi, > > I have been studying the basic limi

Re: Possible Commit Syntax Change for Improved TPS

2003-09-30 Thread Jeremy Zawodny
On Tue, Sep 30, 2003 at 01:19:19PM +0100, Oluwaseun Osewa wrote: > Hi, > > I have been studying the basic limitation that the number of > committed transactions per second possible in a relational databases > is limited by the number of writed per second of the underlying hard > disk, since ea

Possible Commit Syntax Change for Improved TPS

2003-09-30 Thread Oluwaseun Osewa
Hi, I have been studying the basic limitation that the number of committed transactions per second possible in a relational databases is limited by the number of writed per second of the underlying hard disk, since each transaction requires at least the write-ahead log data to be flushed to di