Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] performace issue with FOCUS INDEX command
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] performace issue with FOCUS INDEX command
 Login/Join
 
Gold member
posted
table XXX
print *
ON TABLE HOLD AS &EXECHLDFILE FORMAT FOCUS INDEX SUPHG_EMP_ID

this query is performing differently in two different server, one takes 4 minute to execute and the other takes 11 minute, what could be the reason?

This message has been edited. Last edited by: Kerry,


WebFocus 5.2.5
HP-UX(UNIX)
EXCEL, HTML, PDF and OLAP
 
Posts: 50 | Registered: August 04, 2009Reply With QuoteReport This Post
Master
posted Hide Post
Is your input file sorted by Employee Id (your index field) on one server, and sorted by something else, on the other server?




Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2012/Tomcat Standalone Workstation: Windows 7/IE 11 Database: Oracle 12c/Netezza Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer, & ReportCaster

 
Posts: 787 | Registered: April 23, 2003Reply With QuoteReport This Post
Expert
posted Hide Post
What are the two servers running on ?

Memory available, other processes, version of software, etc.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6222 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] performace issue with FOCUS INDEX command

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.