Linear Hash Reporting and Resizing Tool available for OpenInsight v9.4

In an effort to help assist OpenInsight system administrators manage Linear Hash tables, Revelation Software published a reporting and resizing tool called RTI_LH_STATISTICS. This tool will enable OpenInsight system administrators to view linear hash statistics within an application and identify and resize poorly hashed tables.

Poorly hashed/sized tables are one of the most significant reasons for degradation in system performance.

The Remake table option of RTI_LH_STATISTICS utilizes a program called RTI_REMAKETABLE. RTI_REMAKETABLE works by sampling 10% of the rows in a table, calculating the average record size, then making a new pre-sized table with the frame size larger than the average record size and a threshold of 50% to force the table to resize more frequently.

RTI_LH_Statistics is available at no cost to all current Works members and can be downloaded from the Works Download section of our web site.

Revelation Software

Located in WESTWOOD NJ.

View more articles