See what interesting pearl fell on my email today..
Ah, if FB3 were out...

==================BEGIN FORWARDED MESSAGE==================

>From: interbase@...
>Subject: InterBase 7.5 Perfomance Update
>X-BeenThere: interbase@...
>X-Mailman-Version: 2.1.5

InterBase 7.5 is a screamer! Here are some stats to drool over from a
live system:

Processors 4 Xenon 2.8 ghz
Memory 4 gig
OS 2000 Advanced server
Database 89 gig
Buffers 128,000
Page Size 4k

Todays stats:

Avg No of connections 300
Inserts 2.9 million
Updates 1.6 million
Deletes 1.7 million
Store Proc Calls 3.8 million
Trigger Invocations 18 million
Page fetches 2.1 billion ¡ this number wraps
Page Reads 17 million
Page writes 4.8 million

Next transaction 3.6 million
OIT 2.3 million
OAT 2.5 million
OS 2.5 million

Longest running transaction when the data was gathered 11hrs 42 minutes
(yeah it needs to be fixed but with this performance there isnºt a
rush)

System was rebooted at 4:15am after the nightly copy of the database
was completed.

There are roughly 1 million updates still to be done tonight with some
batch process.

Tomorrow is the heaviest load day of the week and no one cares as IB
7.5
will take it in stride without so much as a hiccup....

IB 7.5 just smokes!

keep smiling

Rob
www.mers.com








_______________________________________________
Interbase mailing list
Interbase@...
http://mers.com/mailman/listinfo/interbase

===================END FORWARDED MESSAGE===================