RE: Events Processing - 6004 HP/Infx

["George Sagen" <gsagen@xxxxxxxxxxxxxxxxxxx>]

Mark,

Back on 6.0.02 HP9000/Informix I found several instances where, though the
BPCS application response time was slow, if I took the raw SQL, plugged in
values in place of the question marks, then dropped the statement into
DBAccess (or any other tool) the database returned the resulting record set
lightening fast. In those cases (I think INV300 was one culprit) SSA changed
the application code and performance improved though the SQL statement
remained static. So my question is, is it really the SQL statement, or is it
what BPCS does with it? My experiences with Informix were that it was very
fast, and relatively easy to install and configure.

George Sagen
BPCS Application Consultant
gsagen@primesourcetech.com <mailto:gsagen@primesourcetech.com>
http://www.primesourcetech.com
PrimeSource Technologies
7373 East Doubletree Ranch Road
Suite 150
Scottsdale, AZ 85258
(801)360-6360 Direct & VM
 


.  -----Original Message-----
.  From: uucp@Uucp1.mcs.net [mailto:uucp@Uucp1.mcs.net]On Behalf Of Mark
.  Curtis
.  Sent: Thursday, June 17, 1999 1:20 AM
.  To: BPCS-L@midrange.com
.  Subject: RE: Events Processing - 6004 HP/Infx
.
.
.  George,
.
.  Yes, but good guess.
.
.  We regularly export, drop and import the dB to get around the extent
.  problems
.  inherited from the prime database (initial & next extent of 16).
.
.  With a dbexport/dbimport most (!!!but not all!!!) tables
.  including glh have
.  an update stats done.
.
.  The Select
.  ----------
.
.  SELECT
.
.  lhid,lhldgr,lhbook,lhyear,lhperd,lhjnen,lhjnln,lhian,lhdram,lhcra
.  m,lhdrat,l
.
.  hcrat,lhlsts,lhstat,lhldes,lhjrf1,lhjrf2,lhdref,lhddat,lhreas,lhb
.  kov,lhuser
.
.  ,lhdate,lhtime,lhlock,lhsumf,lhsln,lhtsn,lhtrnn,lhdrmr,lhcrmr,lhs
.  tmr,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
.
.  The dbexport SQL
.  ----------------
.
.  update statistics high for table glh
.
.       lhbkov, lhbook, lhcram, lhcrat, lhcrmr,
.       lhdate, lhddat, lhdram, lhdrat, lhdref,
.       lhdrmr, lhian, lhid, lhjnen, lhjnln,
.       lhjnml, lhjrf1, lhjrf2, lhldes, lhldgr,
.       lhlock, lhlsts, lhperd, lhreas, lhsln,
.       lhstat, lhstmr, lhsumf, lhtime, lhtrnn,
.       lhtsn, lhuser, lhyear, serialcolumn)
.       resolution 0.50000 ;
.
.  I belive that if the select uses BETWEEN the engine makes little use of
.  indexes,
.  even if (as in this case) the FROM and TO values are the same. Unless
.  someone else knows better !
.
.  Rgds
.  Mark Curtis
.
.  -----Original Message-----
.  From: owner-bpcs-l@midrange.com [mailto:owner-bpcs-l@midrange.com]On
.  Behalf Of George Sagen
.  Sent: 16 June 1999 21:54
.  To: BPCS-L@midrange.com
.  Subject: RE: Events Processing - 6004 HP/Infx
.
.
.  Have you tried to update statistics high on the glh for those
.  columns in the
.  select statement?
.
.  George Sagen
.  BPCS Application Consultant
.  gsagen@primesourcetech.com <mailto:gsagen@primesourcetech.com>
.  http://www.primesourcetech.com
.  PrimeSource Technologies
.  7373 East Doubletree Ranch Road
.  Suite 150
.  Scottsdale, AZ 85258
.  (801)360-6360 Direct & VM
.   
.
.
.  .  -----Original Message-----
.  .  From: uucp@Uucp1.mcs.net [mailto:uucp@Uucp1.mcs.net]On Behalf Of Mark
.  .  Curtis
.  .  Sent: Wednesday, June 16, 1999 7:23 AM
.  .  To: BPCS-L@midrange.com
.  .  Subject: Events Processing - 6004 HP/Infx
.
.
.
.  +---
.  | 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
+---