Hi Folks:
Sorry to keep bugging you about this but I can't seem to figure it
out. This is the continuing sage of the sluggish database. I had
changed one calc that I have used successfully for years to create
schedules.
The hesitation (I'm now calling it) occurs when I navigate from any
layout to one in particular that has the schedule fields. I use a
script that sets a number field with the Get(portal row number) than
moves to the schedule layout via related records than goes to the
portal row based on the number field. It seems that at the last step
is where the hesitation occurs. I've changed the script at that point
without results. There are look up fields but they shouldn't be
operating at that time. On other remote computers a "Find in
Progress" comes up. Yet the only find is the portal row.
I'm confused,
Peter
A repost below of the original.
I have a print production database in FMP 8.5 advanced that
schedules work as well as stores information and specifications.
One of the many calculations I use is this one called "PrintDays"
Case(Web_Print = "Print";Round(Case(PartQty ≤ 100 ;3 +AddPrtDays;
PartQty ≤ 1000;5+AddPrtDays;PartQty ≤ 5000;7+AddPrtDays;PartQty
≤ 10000;14+AddPrtDays;PartQty ≤ 19999; 17
+AddPrtDays;PartQty ≥ 20000; 21+AddPrtDays);
1);Web_Print="PDF";0;1;0)
It determines the number of days that might be required for the
printing of a job based on the quantity. I can amend the number of
days by adding or subtracting days in this field "AddPrtDays"
making the actual number of days for printing more accurate.
In an attempt to "improve" the calculation I added a step at the
end that was specific to one project we do. And that step used the
operator "and" to compare two fields and then based on the
comparison modify the "AddPrtDays" filed. Well that sent the
database of 2600 plus records into a tail spin. It was stuck
trying to compare and modify that field. I even let it run over
night, but the next day it was still trying. So I forced quit,
opened the one database of the eight that comprise the complete
database and did not open the others so that I could go back to
the calculation and reset it back to the way it was; without the
operator "and".
Now it runs better but is still slow on the host computer, but it
is very sluggish over a Filemaker network, to the point where the
other users have to force quite Filemaker to get out of it.
I have update the "AddPrtDays" field to force the calculation to
calculate (it is set to calculate only when necessary) but still
the database is sluggish.
Any ideas on how to improve speed?
