Jared Bratu

Monitor the Progress of OpenInsight 9 Index Update or Rebuild

dbmgrWhen rebuilding or updating a large index in OpenInsight 9, the user interface can go into a Not Responding state even though the rebuild or update process continues to perform the task. This leaves the user uncertain if the process is working or when it might complete. This blog article provides a strategy for working around this issue so you can monitor the process.

Continue reading

PowerShell as an OpenInsight TCL Enhancement

PowerShell

The TCL (The Command Line) window is an invaluable part of OpenInsight, but at times it can feel restrictive or wanting for more features. This blog article demonstrates how Windows PowerShell can be a flexible enhancement for the command line window with a minimal learning curve while making the task of querying OpenInsight data a lot easier.

Continue reading

Copying the Universal Driver 5 to Another Server

UD 5.0

To install the Universal Driver 5, Revelation Software provides a temporary installation key for use during the installation process. This is different from previous versions of the Universal Driver where a static serial number was needed during installation. While the Universal Driver 5 installation key’s expiration date is sufficient for most projects (and can be extended upon request) you may find yourself in the situation of having an expired installation key after hours but need to migrate to a new server. While installing from the setup file is the preferred installation method you can manually copy the Universal Driver 5 to a new server following these steps.
Continue reading

Resolving Open File Security Warning when Launching OpenInsight

SRPLauncherThe standard multi-user deployment practice for OpenInsight involves executing OINSIGHT.exe across the network from a shared network folder. By default Windows distrusts network folder locations that haven’t been previously trusted and can’t be detected as part of the local intranet. This results in Windows displaying the Open File – Security Warning before launching the program.

OInsight.exe File Security Warning Message

In this article we’ll cover 3 methods to prevent the Open File – Security Warning by configuring Windows to trust the shared OpenInsight network location.
Continue reading

OpenInsight LinearHash Service and High Server Memory Usage

UD 5.0

The rule of thumb when it comes to the Universal Driver’s LinearHash service and server performance is to have enough free physical RAM available on the server to fit all the commonly accessed OpenInsight database files (the LK and OV files managed by the LinearHash service) into memory. This article walks through the problems associated when requests for commonly accessed LinearHash files exceed the amount of available server memory.

Continue reading

Comparison with 400 Clients – UD 5.0 Benchmarks – Part 4

UD 5.0

This is a continuation of our series focusing on the performance difference of the Universal Driver 5 and 4.7. In what is likely to be the last article in the series, we resume testing the number of simultaneous clients and the rate in which they are able to read records from the Linear Hash service. Please note, however, that these tests were performed with UD 5.0.0.2. Since then, Revelation Software has released two more patches. The latest patch addresses some rather significant performance issues which were identified in the wild. Given that our tests are synthetic, we do not expect the following results to vary much. Therefore we opted not to retest our results in the latest release. Continue reading

Comparison with 50 Clients – UD 5.0 Benchmarks – Part 3

UD 5.0

The previous articles in this blog series focused on the performance differences between the UD 5 and 4.7 by running tests directly on the server where the Linear Hash service was installed. This essentially limited our tests to single client loops that didn’t have the latency introduced by the network.

In this article the tests will focus on running OpenInsight across the network in parallel from 5 servers running multiple copies of the test program.

Continue reading