I don't know if you have a lot of calutlation marked as "Unstored, but
if you can change some of them to stored that might help.
Just a thought,
John
On Nov 14, 2008, at 2:29 PM, Peter Kilcoyne wrote:
Thanks, Bill. I tried this but alas no luck. There were only 2
summary functions and I deleted both and still it hung up. I amd
afraid I have to rebuild at least part of the db.
Peter
On Nov 14, 2008, at 12:05 PM, [EMAIL PROTECTED] wrote:
Guessing without putting hands on it, but it may be that you have an
average or summation which is being recalculated with every record
calculation. Try letting the calculation happen while you are
looking at
a blank layout for the TO. Then try it with only the calculation
that you
changed showing.
Bill Holt
On Fri, November 14, 2008 11:52, Peter Kilcoyne wrote:
This is really a re-post of an earlier problem. I have a FM 8.5
advanced database the consists of 8 tables that are related and
shared thru
Filemaker network. A week or so ago I made what I thought
was a minor update to a calc. It began "Recalculating" 2,664
records. A
minute later is was down to 2,663 records. Prior to that change the
database was running fine.
Two nights ago, after checking relationships, rebuilding a calendar
table that I had hoped would solve the problem, I changed the calc
again.
It began it's recalculating of the 2,664 records. Since it was
already late in the day I left it running and went home. The next
day it
had only gotten through 784 records. There is even a hesitation
when I
access the scripts; they open, but for a moment the box is blank ,
like it
is looking for something, then finds it and the scripts come in.
I have had out IT service check my computer and I have run virus
programs, I have consulted with Filemaker. I've saved compressed
files,
made clones, and rebuilt one table.
I know I'm asking a lot since you can't experience the problem in
email, but if anyone has any ideas I would really appreciate them
since the
only solution I have is to rebuild the whole thing from scratch at
this
point. I have back ups of the data but not the structure. Lesson
learned.
Peter
________________________________________________
John Haley, Information Technology Supervisor
Always In Season
713/681-1414 (Office)
Visit our website www.AlwaysInSeason.com
