[CLOSED] performace issue with FOCUS INDEX command
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
January 04, 2012, 12:36 PM
David Briars
Is your input file sorted by Employee Id (your index field) on one server, and sorted by something else, on the other server?
Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster
January 04, 2012, 03:32 PM
Waz
What are the two servers running on ?
Memory available, other processes, version of software, etc.