TMG-L Archives

From: "Astrid Kranzbuhler" <>
Subject: RE: [TMG] Excessive time to create a Journal Report
Date: Fri, 3 Dec 2004 11:23:09 +1100
In-Reply-To: <004701c4d8a7$239dd1e0$b6d25344@cj534055a>

Phil wrote:
> I started creating an ancestor Journal report last nite about
> midnite. It's
> now 14 hours later and the report still hasn't finished.

[snip]

> I brought up
> my email this morning the window stopped updating (which is
> normal) but at
> that time it had done 50 generations (that took almost 7 1/2
> hours) and was
> showing 230,000 somethings and 310,000 total people. That's
> over 10 times
> the size of the dataset it's drawing from. Something doesn't
> seem right.
>
> Every hour or so I get a flurry of disk activity and the CPU
> usage drops to
> near zero for a few seconds and then climbs back up to 95% plus.
>
> What's going on??? Why the excessive time? Why so many people?
> Why...?????

Hi Phil,

I strongly suspect that you've set the filter for the report to include each
person as a progenitor and therefore there will be 'new' journal reports for
each person with all their descendants included again .. and again .. and
again ... you said there should be 4000 persons ... imagine 4000 separate
journal reports with the respective descendants included in each.

You'll want to set the filter to just the top of line progenitor and do
*not* select 'Spouse, Ancestors or Descendants' at the bottom of the filter.


Filter:
ID Number ... Equals ... (ID number of top of line progenitor) ... End

If that doesn't do what you want, please tell us what your filter is and
what you're trying to accomplish ...

Astrid

This thread:

• Excessive time to create a Journal Report by "Phil DeSilva" <>
  • Re: [TMG] Excessive time to create a Journal Report by "Phil DeSilva" <>