Re: Best aproach for multiplatform RDBMS development

JPL, The environment is Transportation, and although we are not getting continuous 7x24, they are bursts lasting multiple hours at a time. Imagine having a Yard receiving containers every hour of every day, and then a Typhoon comes through that closes the yard for 2 days. When the Yard opens again, we have two days worth of Containers to receive and some of the ships from the two days of closure to load.

I suppose the only thing that you will have to worry about, is that HOT BACKUPS will be done at this high throughput rate. We ran tests for this scenario and survived OK, but I don't think we ever needed to do the backup for real at this peak loading.

Andrew
BTW - As far as Records per second are concerned, at the lowest we were at about 30 records per second, at 3:00AM

Jplahman wrote:

> In article <37246E69.9494472E_at_mail.com>, Andrew Babb <andrewb_at_mail.com> writes:
>
> >I am not talking records, but transactions, and we were achieving 10
> >transactions
> >per second and between 90 and 110 rows per second on an HP-UX platform.
> >You'll make
> >your 18 records per second provided you have the correct hardware. This on
> >7.3.4
> >and no chance of partitioning and Parallel DML.
>
> Is this continuous. In a steel mill, we constantly receive 18 records/sec, 24
> hours a day, 7 days a week.
>
> BTW, what is your application?
>
> Thanks
>
> JPL
Received on Mon Apr 26 1999 - 18:10:26 CDT