Re: nVision for Peoplesoft

["Kearns, Gary" <KearnsG@HSN.NET>]

I have a document which explains some of the performance enhancements I
was referring to within the nVision tool itself.  These build the
selector tables dynamically and are attached to layouts.  If you send
your fax number, I'd be happy to send it.

Also what chartfields are you using in the nVisions?  We added indexes
on the PSTREESELECTxx (xx is the size of the field) tables that you are
accessing.  For instance, we have dept level rpts which use
PSTREESELECT10.  I have added an index SELECTOR_NUM, RANGE_FROM_10 and
have noticed performance improvements.  We did this likewise to
PSTREESELECT08.

The SQL is very inefficient.  I've run explain plans and it typically
does a complete table scan against the ledger or ledger_budg.  None of
the selects use business_unit so they by-pass the index.  They all use
ledger, account, etc...  I plan on creating some indexes in the hopes to
get the nVision SQL to use them...

Hope this helps.  Good luck.

Gary

Gary Kearns
HSN PeopleSoft Implementation
(813) 572-8585 x5070
kearnsg@hsn.net


> -----Original Message-----
> From: Parenteau, Brian P. [SMTP:BPParenteau@CVS.COM]
> Sent: Wednesday, July 08, 1998 3:03 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      nVision for Peoplesoft
>
> Hi All,
> I know this list is mostly for technical info on SQR's, but I'm
> assuming
> that a lot of you have experience with Peoplesoft.  So my question
> is....has
> anyone had any experience with PS/nVision...or know where I can get
> some
> information about it? We are having serious performance issues trying
> to run
> a report against a large amount of data.
>
> Any help would be greatly appreciated.
>
> Thanks
>
> Brian