Hi there,

My company bought a new server with the following specs:

HP G5 Server

Dual Intel Xeon Quad Core - 2GHz

4GB Ram

8 x HD's in Raid.

2 x gigabit Network ports.

Windows Server 2003 R2 with service pack 2

We then upgraded OI to version 8.01. We are also using Universal Driver 3.0. The problem that we are having is the speed. It is incredibly slow. How can this be with a new server? Our old server ran faster than this. If I run OI on the server then it runs very fast but across the network its slow. If I transfer files across the network using windows copy then its very fast. What could be wrong to make OI slow?

Please can someone help?

Do you have a revparam file in the OpenInsight subdirectory?

If there is no revparam, then UD3 driver will search for it, which can make OI run slowly.

Besides revparam, two other ideas:

- Exclude .LK and .OV files from Virus Scanning software.

- Configure UD to run in pure TCPIP mode.

Steve,

After following Bob's advice (if it doesn't help), you may want to consider uninstalling/reinstalling the UD service. It seems that no matter how many settings you tweak, this may be the best course of action. I've see this happen on more than one occasion and a reinstall of the service has resolved the issue on nearly all instances where application slowness was the issue.

ftomeo@srpcs.com SRP Computer Solutions, Inc.

Couple of ideas if you are configured for TCPIP

Make sure the port # you are using is not being scanned/managed by any virus protection.

Since you put in a new server, make sure the clients have refreshed their DNS. You can confirm this by pinging from the client. If that is slow, well…

Hi there,

Thanks for all the advice. I do have a REVPARAM file and we have re-installed the UD3 once already. When we first installed, we decided to run it in pure TCP mode but that turned out to be slower than the mixed mode. I will try to exclude the files from the virus scanners and see if that helps.

Would upgrading to UD4 help?

Thanks again for all the help.

Anacdotally UD4 gives a significant speed / performance incriment over UD3, specifically in default tcp/IP mode.

On one site we have just completed the upgrade. Previously the were forced into mixed mode - now can run tcp - and IT people are wearing broad smiles on their faces. I believe that the UD4 does a better job in caching selects.

Richard Bright

Hi There.

I have installed UD4 and there has been a major reduction in network traffic. The processing of data seems to be a lot faster but the User Interface is still slow. Whenever you click on a button or something like that then it takes forever to do something. When you run a report or do any database intensive process then it fly's. Its just the UI which is slow.

What could be wrong??

Can you give some examples of what is running slow?

Hi Aaron,

Its anything to do with the user interfce like if i open a window then you sit and wait. It takes about 30 seconds to appear. If you click on a button then it takes about 30 seconds to run the code behind that button.

If I run something that does a lot of data processing like a report then it takes about 30 seconds to open the report window but when the report acctually runs then it is extremely fast.

What could be wrong…is it server related or have i setup OI incorrectly?

Thanks.

Is there an LH3.log or lh4.log file in the openinsight directory?

Is there a revparam file in the Oinsight directory?

Are you running with pure TCPIP settings, NAMEDPIP=None

Have you disabled virus scanning of .LK and .OV files?

Are there any error messages in the Windows Event Viewer?

If you use a TCPIP named engine does speed get better?

for example, \\myserver\mypath\oinsight.exe /sn=8123.

What about a problem with a SYSTemp or SYSLists? If there was a resize issue wouldn't that cause slowdowns? What I found interesting is that once a program starts it works fast…

HTH,

John

I agree with John, it could be access to one of the system files that's the problem. Most of OI runs through oengine, so the speed of everything should be more or less the same, after all, almost everything is a record in a file.

Run LHVERIFY tests on SYSOBJ, SYSREPOS, SYSREPOSWINEXES, SYSREPOSEVENTEXES and SYSLISTS checking for access speeds.

Hi there,

There is no LH3.log or lh4.log file in the openinsight directory?

There is a revparam file in the openinsight directory.

There is no NAMEDPIP=None in the revparam file but in the registry there is a "NamedPipeName=none".

I have disabled the virus scanning for .LK and .OV files.

There is an error message in the event viewer :

The description for Event ID ( 30000 ) in Source ( LinearHash ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: LHReadRecord, 1009, 2, 0, ???..

I have no clue what that means.

When running the command '\myserver\mypath\oinsight.exe /sn=8123.' it does not run faster.

Thanks.

Has this been resolved? We have a very similar problem with UD4. Everything looks right but it runs slow, slow, slow. A login that should take 3 or 4 seconds takes a couple of minutes.

We are using TCP/IP with the default 777 port number and the server's actual IP. I assume this is correct, not 127.0.0.1 as shown in the tutorial video.

View this thread on the Works forum...