Linear Hash Sizelock Administration Tool for OI v9.4 released


In conjunction with the Linear Hash Reporting and Resizing Tool released in March 2016, Revelation Software are publishing a sizelock administration tool called RTI_SET_SIZELOCK.  This tool will enable OpenInsight system administrators to view linear hash statistics within an application and identify and modify the file sizelock parameter.

The sizelock parameter is used to control the automatic resizing of the primary address space. A sizelock of “0” indicates that a table should be allowed to expand as more rows are entered, and become smaller as rows are deleted. A sizelock of “1” indicates that a table should be allowed to expand, but should not become smaller. This is useful in cases of a presized table, when a preliminary expectation is for the table to hold 1000 rows, but more rows may be added. If a sizelock is set to “2” or more, the table is not allowed to expand or contract. A sizelock of “2” is very important during a select operation executed on a network, when one user is searching a table for information while another user is entering new data.

OpenInsight increments the sizelock by 2 for the duration of the select operation. If another user is adding information, it is possible that the system could determine that a table needs to be resized. If this were to occur during a select operation, the process might yield unpredictable results: rows that have not yet been evaluated might be skipped, or rows might be processed more than once. Because the sizelock is “2”, no resizing takes place. Once the process is finished, the sizelock is decremented by 2, restoring it to the table’s original sizelock value. While the table might now be slightly out of size, the addition or deletion of another row will result in correct resizing.

The RTI_SET_SIZELOCK tool will allow an OpenInsight system administrator to globally set the sizlelock parameter on all or select tables.  For instance if a sizelock parameter is set to “2” or greater the table will not resize.  You can use this to disable resizing during busy periods and then re-enable resizing during quiet periods.

You can use this tool on any table, including ! and DICT files, as well as system files such as SYSLISTS and SYSOBJ.

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

Advertisements

Universal Driver 5.0 to be made available for use with OI 9.4


Revelation Software are so pleased with the features and benefits of the Universal Driver 5.0 that we are going to make it available for use with OpenInsight 9.4 in October 2015!   Existing users of the Universal Driver 4.7 can upgrade to the Universal Driver 5.0 and customers who are not upgrading, can purchase the UD 5.0 as normal.  If you are in the EMEA region, please email martyn@revsoft.co.uk with your current version and serial number for the cost of your upgrade.

As with the current Universal Driver 4.7 for OpenInsight version 9.x, the UD 5.0 will be included free of charge with the purchase of new OpenInsight 10 licenses.

Features and Benefits

  • Latest Communication Technology
    The Universal Driver 5.0 utilizes the latest communication libraries to provide robust, reliable service between the UD server and its clients.
  • Secure communications option
    If desired, the communications channel between the UD server and its clients can be SSL encrypted, preventing unauthorized interception of sensitive information.
  • Authenticated clients option – If desired, only explicitly authorized client software can connect to the UD server over a secure SSL channel.
  • Connection Retry
    If the communication link between the client and server is temporarily lost, and then restored, the client will attempt to reconnect and resume normal operations.
  • VSS friendly
    The UD 5.0 is VSS (Volume Snapshot Service) aware and can thus be backed up with minimal disruption to normal operations.  

New Development Being Planned


No, this is not something new for OpenInsight 10 (OI10), or something else altogether.  It’s a new personal project that is long overdue, but which has OI10 well and truly in mind.

I obviously dive into OpenInsight on a regular basis to undertake live demonstrations to interested people, prospects and the like, but that tends to be a need, feature, benefit, style of approach and it never really gets into application development planning and building.  However, this week I found myself delving further into the development tools and immersed in code to add a new module to my RevSoft UK Contact Manager.  Having not developed anything in quite some time, it was a) nice to find that I could still knock up something really quickly using OI 9.4 and b) not so nice to find just how rusty I had become.

Anyway, with the conference now only a few short weeks away, OI10 looming and a development project begging to begin, I thought it best to dive back into OI development.

As a hobbyist developer at best, it never amazes me to find what I can achieve with the toolset and this time my sights are set on trying to build the new system more slowly and better.  I’ll be looking at exploring error trapping and I might even have a quick dabble at using commuter modules.  All of this will begin with the current 9.4 version and then I will switch into OI10 just as soon as RevUS have a beta for me to play with.

Having started M4Photo nearly a year ago, it is now high time that I got myself organised and this new development will be an application to run the hobby business.  I’ll begin with Contacts and Organisations because I need those modules like yesterday.  I’ll then move onto a simple marketing management module for bulk email blasts and paper campaigns, and then I’ll computerise the sales and invoice side of the business.  Lastly, I’ll dive into the Banded Report Writer (BRW) for mail merging and other reports.

Don’t expect to see too much of this project on the blog anytime soon.  OI 9.4 development will shortly be old hat and I’ll keep the progress updates for when I dive into OI10.

In the meantime, watch for my conference updates via twitter and the blog during the conference week.