Problem Mass Deleting Files

[hoonsong]

Hi,

I have problems mass deleting files within my LES971, I tried LIvelink Explorer, WebDAV and traditional Webpage methods but I keep getting timeout errors (e.g. CGI timeout). The only way I can delete them is drilling them into file level and deleting them one by one. Note that browsing my LES971 is quite slow. I think the bottleneck is in my database (my dtree has 4 million rows and the tablespace is 335GB). I am deleting files to do housecleaning but browsing and deleting them is taking too much time.

Is there a more efficient way to do this? Any help will be greatly appreciated. Thanks! =)

Hoon Song

 

[ggriffit]

you could try increasing the CGI timeout value on your webserver alternatively you may be better off scripting this up using WebServices / LAPI if there are a lot of content to be pruned.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[hoonsong]

Thanks for relying.

All the files I want to delete are within a single folder.

Is it recommended to configure an indefinite timeout and try to delete that single folder. Hope it does run out of memory of anything.

With regards to using LAPI, does using Explorer equate to using LAPI? I tried using Explorer to delete the main folder but it timed out nevertheless. I still have to browse to the subfolders to delete them individually.

 

[hoonsong]

Since my installation is running quite slowly and I am suspecting the bottleneck is at the database, I am thinking about running level 1 to 5 diagnostic Oracle Server Maintenance Tasks... but I have the following concerns:

1. I am afraid that it might slow the system too much and if it does can I stop the diagnostics mid way?

2. Or it might corrupt the database due to its size (it is 35GB not 335GB... sorry for the typo).

 

[ggriffit]

LAPI the Livelink API's so you can create a script to pull back a list of nodes to delete, perhaps via SQL or using one of the LAPI functions and then run the DELETE command on each node or just the sub folders etc.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[hoonsong]

Thanks. Using LAPI to delete seems to be the easiest way to do it. However it does slow down the server to the extend usr experience on the webfront is affected (logging in and browsing folders takes especially longer till they get a CGI timeout). Any way around it? Can I increase the no. of threads for the livelink server? In the meantime we are thinking of setting up another livelink server for deleting files so that it does not affect the existing one that is serving the users direct via the webfront.

 

[appnair]

That is how you usually do maintenance on livelink en masse.Mostly the database can handle the load but you are restricted by available livelink threads.also your lapi program will run faster if you give it the dataids to work on basically thru sql queries.if you do lapi.listobjects it is expensive and will take time.

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