Slow report when searching on dtree.

Shaz_Amin

I have a live report which currently takes about 10 seconds to run , The report is designed for user to input a student number and then click on the hyperlink to get into the student folder.The report is ...Select * from Dtree where name =%1 and modifydate >= '01-JAN-2006'%1 is a user input string.Any ideas on making it run a lot quicker?

Lindsay_Davies

Message from Lindsay Davies via eLinkHi Shaz,Oracle or SQL server?Run the same SQL through a regular client tool and get anexplain/execution plan.Is this a personal workspace or a defined folder object?You could add a subtype= clause to your query to try to make it faster. Where subtype = 0 and name = %1 etc.It sounds like you are specifying the output as Livereport: format.You could replace "select *" with %2 (defining this as "Report Fields")but that is no going to make too much difference.If this is Oracle and you use Choose, then the statistics need to be upto date to make calls quick.Whether Oracle or SQL Server, it may help to have all the columns in thewhere clauses available in a single index.However, adding additional indices is a two-edged sword. There may be one you can modify instead.Maybe an index that contained modifydate and name (and subtype of youadd that clause)Is the report going to be run so often to demand fastest performance?Good luckLindsayUK-SupportOpen Text -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 06 February 2007 11:16To: eLink RecipientSubject: Slow report when searching on dtree.Slow report when searching on dtree.Posted by Amin, Shaz on 02/06/2007 06:13 AMI have a live report which currently takes about 10 seconds to run , The report is designed for user to input a student number and then clickon the hyperlink to get into the student folder.The report is ...Select * from Dtree where name =%1 and modifydate >= '01-JAN-2006'%1 is a user input string.Any ideas on making it run a lot quicker?[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.