How many time_bomb records do you generate per day?
Curious: on average, how many time_bomb records does your Clarify system generate per day?
How can you determine
this?
Assuming you’re not using objid caching (which is the
typical scenario), simply take note of
the current maximum objid in table_time_bomb.
Here is sample SQL for doing this:
select max(objid) from table_time_bomb
Take note of the date and
time. Then, simply run the same query a
day later, again taking note of the date and time. Subtract the two objids, and that will tell you approximately
how many time_bomb records have been
processed in that time period.
