Job Matl Report Question

Maybe when you put the job filter back you put it in a different spot in the
pecking order?

Patrick

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, July 18, 2002 11:21 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Job Matl Report Question


I've seen odd things like this with RB many times and my guess has been that
along the way, in the process of making changes, it "knew" if it had to go
back to the database or just use what had already been read and stored
locally. So at one point a change that may have slowed it down only when
reading from the server instead used previously read data and still ran
fast. Then at some point RB decided it had to go back to the server
(usually filter changes trigger this) and it slowed down. This makes it hard
to tell exactly which change cause the slowdown. My only guess at why your
filter changes didn't trigger a DB read would be that the filters were
"within" the scope of the data it already had locally.

My usual strategy would be to examine all the links and make sure they
conform to keys (all fields and in the same order) and then to order the
filters (after company code) from most restrictive to most common - that is
"what's going to weed out the most record complexes should be first". This
helps avoid subsequent reads to the linked tables. When you added the
projects tables (which I have no experience with) it might have
significantly multiplied the number of records being selected, especially if
link keys were not unique enough. Just a few guesses.
-Todd C.

-----Original Message-----
From: Nora Story [mailto:Nora_Story@...]
Sent: Thursday, July 18, 2002 10:14 AM
To: vantage@yahoogroups. Com
Subject: [Vantage] Job Matl Report Question


I could use some enlightenment about what might be slowing down a report
builder report I am trying to modify. The original report gets information
from JobMatl table only with sorts by jobnum and partnum and filters by
company and jobnum, preview pops up fast. I added joins to JobHead and
Project tables so I could get the report by project, added sort for
projectid as first sort with job sort now second, and added filter for
project id (the job filter was still there then). I was doing previews at
each step along the way and the report still popped up fast.
I then removed the job filter in order to see the whole project and that's
when the report started taking forever to preview. I went back and added a
job filter back, and the report still took forever. I deleted the project
filter and report still ran slow. What would have caused the slowdown of
the report at the project filter/sort level, and why wouldn't the
performance go back to where it was before if I returned the settings to a
previously fast level?
Any help would be greatly appreciated!
Thanks,
=======================================================================
Nora Story
Spectra Technologies, Inc.
Project Administrator
1505 Royal Parkway

Phone: 817-540-4475 ext.105
Euless, Texas 76040
Fax: 817-540-4439
Nora_Story@...
=======================================================================




[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=228862.2128520.3581629.1829184/D=egroupweb/S=17050071
83:HM/A=1155070/R=0/*http://adfarm.mediaplex.com/ad/ck/990-1736-1039-302>


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
I could use some enlightenment about what might be slowing down a report
builder report I am trying to modify. The original report gets information
from JobMatl table only with sorts by jobnum and partnum and filters by
company and jobnum, preview pops up fast. I added joins to JobHead and
Project tables so I could get the report by project, added sort for
projectid as first sort with job sort now second, and added filter for
project id (the job filter was still there then). I was doing previews at
each step along the way and the report still popped up fast.
I then removed the job filter in order to see the whole project and that's
when the report started taking forever to preview. I went back and added a
job filter back, and the report still took forever. I deleted the project
filter and report still ran slow. What would have caused the slowdown of
the report at the project filter/sort level, and why wouldn't the
performance go back to where it was before if I returned the settings to a
previously fast level?
Any help would be greatly appreciated!
Thanks,
=======================================================================
Nora Story
Spectra Technologies, Inc.
Project Administrator
1505 Royal Parkway

Phone: 817-540-4475 ext.105
Euless, Texas 76040
Fax: 817-540-4439
Nora_Story@...
=======================================================================




[Non-text portions of this message have been removed]
I've seen odd things like this with RB many times and my guess has been that
along the way, in the process of making changes, it "knew" if it had to go
back to the database or just use what had already been read and stored
locally. So at one point a change that may have slowed it down only when
reading from the server instead used previously read data and still ran
fast. Then at some point RB decided it had to go back to the server
(usually filter changes trigger this) and it slowed down. This makes it hard
to tell exactly which change cause the slowdown. My only guess at why your
filter changes didn't trigger a DB read would be that the filters were
"within" the scope of the data it already had locally.

My usual strategy would be to examine all the links and make sure they
conform to keys (all fields and in the same order) and then to order the
filters (after company code) from most restrictive to most common - that is
"what's going to weed out the most record complexes should be first". This
helps avoid subsequent reads to the linked tables. When you added the
projects tables (which I have no experience with) it might have
significantly multiplied the number of records being selected, especially if
link keys were not unique enough. Just a few guesses.
-Todd C.

-----Original Message-----
From: Nora Story [mailto:Nora_Story@...]
Sent: Thursday, July 18, 2002 10:14 AM
To: vantage@yahoogroups. Com
Subject: [Vantage] Job Matl Report Question


I could use some enlightenment about what might be slowing down a report
builder report I am trying to modify. The original report gets information
from JobMatl table only with sorts by jobnum and partnum and filters by
company and jobnum, preview pops up fast. I added joins to JobHead and
Project tables so I could get the report by project, added sort for
projectid as first sort with job sort now second, and added filter for
project id (the job filter was still there then). I was doing previews at
each step along the way and the report still popped up fast.
I then removed the job filter in order to see the whole project and that's
when the report started taking forever to preview. I went back and added a
job filter back, and the report still took forever. I deleted the project
filter and report still ran slow. What would have caused the slowdown of
the report at the project filter/sort level, and why wouldn't the
performance go back to where it was before if I returned the settings to a
previously fast level?
Any help would be greatly appreciated!
Thanks,
=======================================================================
Nora Story
Spectra Technologies, Inc.
Project Administrator
1505 Royal Parkway

Phone: 817-540-4475 ext.105
Euless, Texas 76040
Fax: 817-540-4439
Nora_Story@...
=======================================================================




[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=228862.2128520.3581629.1829184/D=egroupweb/S=17050071
83:HM/A=1155070/R=0/*http://adfarm.mediaplex.com/ad/ck/990-1736-1039-302>


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]