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.
