Peter, Only gave this a quick read but suggest using a script to deposit the results of the calc in a plain Number field. Any time you change something hit the 'update' button. -- Steve Gerow FileMaker 8/7 Certified Developer
President Abrazos Data Consulting, Inc. Pasadena, California Member FileMaker Bus. Alliance > -------Original Message------- > From: Peter Kilcoyne <[EMAIL PROTECTED]> > Subject: Database Sluggish after calc change > Sent: Oct 30 '08 06:40 > > Hi Folks: > > 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? > > TIA, > Peter
