Moving folders & documents in bulk

[appscript]

Hi,

Livelink 9.7.1

What is the best method of moving folders which contain other folders / document in bulk when there is a lot of data involved.

From experience, moving using the interface grinds the system to a halt & the database has to be cleared.

Is this this still the best way of doing it but in smaller amounts? or is there a better way (Webreports etc & not impact on the system in this way) - we still dont understand WHY the system performance is affected so much doing this.

Thanks

appscript

 

[appnair]

As I posted to another user every livelink instance's performance can only be gauged correctly if like very other organization you are following best practices on sqlserver,oracle,webserver and so on.livelink writes out a timings.csv file and using performance analyzer or something you write you yourself can catch things before they go way out of hand.as far as move is concerned if you hired me as a analyzer I would start looking at how many places move has been customized examples being RM,Recommender,Recycle,undelete and so on whether code was written by OT or 3rd party.Also many places stand up a utility livelink server so that bulk processing of this nature happens by not hampering with user clicks and admin server processing.

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

 

[appscript]

appnair,

Thanks for your reply - Yes I understand what you are saying but this is just moving a folder structure from one area of livelink to another & nothing more. This usually works seamlessly but in this example we are doing things in bulk.

We have a seperate LES server for processing of this nature using either object importer/exporter but that still wouldnt get over the DB blocking issue as this looks like its the bottleneck & the system cannot handle this much moved in one transaction and still function correctly.

Having said that, the folders / files did copy over successfully but we want to do this withough users being affected by this kind of work.

Or we do it at a weekend.

Thanks

appscript

 

[appnair]

A lot of oscript fires when you do this and that comes from
lot of modules other than core.If livelink core was only involved perhaps what you were thinking is correct change parentid's in a few places and like that.In fact it is not that way.if you put connect logs you can see the amount of database calls that happen with this.

"Yes I understand what you are saying but this is just moving a folder structure from one area of livelink to another & nothing more."


In my experience I have found bad running queries etc and pointed it out to OT and they have used research that I submitted to make the product better.Several community members do the same that is why I like the company,they hear your pain.If something is unacceptable
to you as to crippling your instance I would try to engage a performance person on your instance.Usually OT provides the best service in that area.






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

 

[appscript]

Thanks for you input here , this will definitely give us something to go on and will contact OT if we think there is a problem then. Will try again soon but hopefully wont have many more large moves to do.

Thanks again,

appscript