nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Categories Livereport to query 1 million documents

Pranjali_Komawar

We have Livelink 9.5 SP1 and Oracle 10G. We have a folder where there are 364 sub-folders and the total document count for all of them is more than 1 million. Now we have a requirement where we have to apply categories to some of the documents under that folder and then display the category information along with the document links using Livereports. We are using the 'Connect by prior Id' in our query, and due to the large number of documents, the Livereport does not run faster to display the output, and sometimes never completes.Can anybody please advise other options such as if there are any other VIEWS etc for categories information, and if we can use something else instead of Oracle's Connect By Prior Id clause, or if anybody has used stored procedures etc. Any advise will be greatly appreciated.

Find more posts tagged with

Comments

Lee_Butler

Message from Lee Butler <lbutler@resonatekt.com> via eLink

eLink

Hi,

It wouldn’t help with the execution time directly but you could use a WebReport and have it write to a document once per day on a schedule – e.g. during the evening when the system load is low. Rather than people viewing the report directly (and therefore execute the SQL statement) you could just have them access the document.

If you needed something more structured than a document in the output – e.g. so that you can run further queries on (sorting, filtering, etc.), you could use a WebReport to write it’s results into a Web Form (using underlying SQL storage). With this in place you could run queries on the subset of data in the form – I guess this would be giving you something close to a view anyway.

Cheers,
Lee.

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, November 11, 2010 4:48 PM
To: eLink Recipient
Subject: Categories Livereport to query 1 million documents

Categories Livereport to query 1 million documents

Posted by pkomawar@metlife.com (Komawar, Pranjali) on 2010/11/11 10:46

We have Livelink 9.5 SP1 and Oracle 10G. We have a folder where there are 364 sub-folders and the total document count for all of them is more than 1 million. Now we have a requirement where we have to apply categories to some of the documents under that folder and then display the category information along with the document links using Livereports. We are using the 'Connect by prior Id' in our query, and due to the large number of documents, the Livereport does not run faster to display the output, and sometimes never completes.

Can anybody please advise other options such as if there are any other VIEWS etc for categories information, and if we can use something else instead of Oracle's Connect By Prior Id clause, or if anybody has used stored procedures etc. Any advise will be greatly appreciated.

[To reply to this thread, use your normal E-mail reply function.]
Discussion:	Open Text Live Reports Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Pranjali_Komawar

Hi Lee ...thanks for your sugesstions, however we do not have Webreports. I wish if we would have had that it would have made life much easy :)Thanks again!

Glenn_Joseph_Heying_(gheying@opentext.com_(Delete)

You may want to discuss this with your DBA. Oracle has an option for caching a view in memory. The view can be refreshed at specified intervals.

Appu_Nair

Message from Appu Nair <anair@alitek.com> via eLink

Check if dtreeancestors table exist

9.5 code needs all the correct patches

For it to work

There is a white paper showing

Best practices for applying categories

If the users can live with it I would

Create a temp table of the subset

Maybe run SQL on the oracle server

It has to somehow complete you

Then query this table rather than dtree

And llattrdata it won't be nearly real time

That is all

Sent from my iPhone

On Nov 11, 2010, at 10:48 AM, "eLink Discussion: Open Text Live Reports Discussion" <livereportsdiscussion@elinkkc.opentext.com> wrote:

Categories Livereport to query 1 million documents Posted by pkomawar@metlife.com (Komawar, Pranjali) on 2010/11/11 10:46

We have Livelink 9.5 SP1 and Oracle 10G. We have a folder where there are 364 sub-folders and the total document count for all of them is more than 1 million. Now we have a requirement where we have to apply categories to some of the documents under that folder and then display the category information along with the document links using Livereports. We are using the 'Connect by prior Id' in our query, and due to the large number of documents, the Livereport does not run faster to display the output, and sometimes never completes.

Can anybody please advise other options such as if there are any other VIEWS etc for categories information, and if we can use something else instead of Oracle's Connect By Prior Id clause, or if anybody has used stored procedures etc. Any advise will be greatly appreciated.