LAPI call performance Issue

[ujjval090683]

I have created code which uses Database query and LAPI(Livelink 9.5) to retrive the Document information. For single LAPI call I am facing performance issue. Initially I had Livelink and Oracle in same machine for testing my code, it was working fine.



Now, I have installed Livelink and Oracle in different machine. But they are at same geographic location network. Trying to run code from another machine in same netwrok. But I am getting major issues in performance



What can be the reason? When I see the logs, For database query it is not taking long time, but for LAPI calls for retriving version information like "listVersions" "FetchVersions" calls, it is taking more than a minue for single call.



I checked the network speed, that is perfectly fine, I checked the CPU usage and memeory, everythign looks fine to me. What can be done in this case? How can I incease performance? Any tuning is required? Database is also indexed.....

 

[appnair]

Have your organization ever brought in any people who know how to analyze performance data in livelink. There is a package available from OT for that.Since you are the same poster in KB on almost the same link and many of us are posting here as well as there it is time to look at some apples to apples comparison.

Livelink 9.5 and lapi calls are very fast provided the livelink server can handle it.

Other than your code do you have a tool like livelink explorer that uses lapi and do they have the same speed reduction.

If OT code(like livelink explorer is slow) perhaps your livelink server is very constrained.It cannot be explained how to performance tune livelink in this public thread.Every livelink install is different so common sense guidelines is what we all offer you in this thread.By that I mean do you have deep containers with umpteen versions on nodes.When you do a listversions on a node that has 25536 version obviously it will be slower.If you do a lapi listnodes on a container that has a millions documents then your code will either hang or it will be very slow

In my opinion if you allow the Performance Evaluators to look at your system and assist the evaluator you will learn how to make your system better.There is no magic bullet to this


Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair