Re: Best aproach for multiplatform RDBMS development

Hi,

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.

Rgds
Andrew

Jplahman wrote:

> We are talking about 18 records per second, every minute, every hour, every day
> for 24 by 7 coverage. At 18 records per second, that's 64,800 records per hour
> or 1,555,000 records per day. I believe this is too big for any database.
>
> Now, you're telling me that I don't have put this first into a global section
> then filter it into a larger time segment before populating a database?
>
> I would like to see some explanation why I can write this amount of records at
> this fast time interval directly into an oracle database. Even if it can be
> done, my server will take a big performance hit.
>
> JPL
Received on Mon Apr 26 1999 - 08:47:21 CDT