RE: Events Processing - 6004 HP/Infx

[Christine Hales <chales@xxxxxxxxxxx>]

Mark,
        
[6004 HP/Oracle]

        In testing 6004, we found the same problem - anything that hit the G/L 
(updates, inquiries, etc.) was taking an overly long amount of time.  We 
moved to a much bigger box, and for the most part, 6004 was much faster 
than 6002, so it didn't make any sense.  What we found was that several 
indexes failed on creation during the conversion - all of which point to 
the GLH table.  There was an error in the conversion scripts (supplied by 
SSA) that we had missed.

        After recreating the indexes - everything moved much faster!  (We have 
roughly double the number of records you mentioned.)
        
                        -Christine



-----Original Message-----
From:   Mark Curtis [SMTP:mark.curtis@hafele.co.uk]
Sent:   Wednesday, June 16, 1999 10:23 AM
To:     BPCS-L@midrange.com
Subject:        Events Processing - 6004 HP/Infx

We are experiencing up to a 20 minute wait to get into a journal using
Events Processing.

Has anyone else had similar problems (I note BMR 49122 is down to address
this issue) ?

If you have and have solved it (e.g. by adding additional indexes) please
let me know as I am being moaned at daily by our accounts staff.

the culprit appears to be an SQL statement fired by the program :

  SELECT

lhid,lhldgr,lhbook,lhyear,lhperd,lhjnen,lhjnln,lhian,lhdram,lhcram,lhdrat,l

hcrat,lhlsts,lhstat,lhldes,lhjrf1,lhjrf2,lhdref,lhddat,lhreas,lhbkov,lhuser

,lhdate,lhtime,lhlock,lhsumf,lhsln,lhtsn,lhtrnn,lhdrmr,lhcrmr,lhstmr,lhjnml
     FROM GLH WHERE (LHLDGR BETWEEN ? AND ? AND LHBOOK BETWEEN ? AND ? AND
    LHYEAR BETWEEN ? AND ? AND LHPERD BETWEEN ? AND ? AND LHJNEN BETWEEN ?
AND
    ? AND LHJNLN BETWEEN ? AND ? AND LHID = ? AND LHLSTS BETWEEN ? AND ?)
    ORDER BY LHLDGR,LHBOOK,LHYEAR,LHPERD,LHJNEN,LHJNLN

that causes a sequential scan of the whole GLH (500,000 + records in our
case)

Regards
Mark Curtis
IT Director
Hafele U.K. Limited
Tel : +44 (0)1788 542020
Fax : +44 (0)1788 541860
email : mailto:mark.curtis@hafele.co.uk
Web : http://www.hafele.co.uk


+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---