January 15, 2008
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.
How many time_bomb records do you generate per day?
January 15, 2008
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.