Steve:
Yes to the first three statements. That is the situation. Yes I did
force quit because it was taking a very long time. I let it run over
night and it hadn't gotten through half of the records. I have made
calc changes before and the recalculation was very fast. I have saved
clones of the tables and have changed the calc assuming that the time
frame would be less. And yes it was but it still took 5 minutes to
change one record.
I would re-make the database (reluctantly) but I don't know which
field def if not all are corrupt. I'm now going through each to each
if all seems well.
This calc involves looking up into a calendar table to bring back a
workday and then creates the next date which in turn does the same.
This covers 9 dates. All of this took seconds before I made the
change. But I did (ashamed to say) make the change while sharing the
file although I don't believe anyone was accessing it at the time or
FM wouldn't let me do it.
Peter
On Nov 14, 2008, at 2:53 PM, Steve Cassidy wrote:
Peter
I'm trying to grasp the situation here...
- You make a change to a calculation. When you close the
calculation pane, something begins recalculating and takes a long
time.
- When the recalculation finishes, the database runs slow
throughout (including in the script editor for example).
- If you reverse the change, the database continues to run slow
throughout.
Is that the situation?
Did you force quit the program during one of these recalculation
processes? If so, it's possible you've corrupted the file(s). The
answer to that would be to revert to a backup. Which is not very
good if, as you say, you haven't got one.
Is there something in particular that makes you think the overall
slowness and the recalculation are connected? Recalculation is
common and, depending on the calculation, can take a very long time
in Filemaker.
Steve
On 14 Nov 2008, at 16: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.
