On 02/16/2012 09:02 AM, Loon, EJ van - SPLXO wrote:
select activity, cast((end_time) as date) as "Date", (examined/cast((end_time-start_time) seconds as decimal(18,13))*3600) "Objects Examined/Hr" from summary where activity='EXPIRATION' and days(end_time)-days(start_time)=0
I'm getting between 900/s and 1300/s. AIX, 5.5, on an EMC VNX with Fast Cache (SSD caching). - Allen S. Rout
