Hi,

I'm new to FM and am trying to crunch some numbers in a file which has over 460K records. (A Whopping 411MBs after a few relookup).

I keep crashing the program when I try a summary field (named TOTALAMT) which adds all the number values in a field called AMT from each record. Is there any way to handle this much info at one go or would I need to break this into smalled files? Help please

Thanks

-J

Date field = max 255 caracters

Number field = max 255 caracters, the first 120 are indexed.

Text field = number of caracters limited only by memory (up to 64000 caracters)

Lenght of fieldname = up to 60 caracters

Number of field repetitions (Sub records) up to 1000 for each field.

So check where the problem is.

You probably have to split your fieldcontents

Thanks for the info... checked the field entries to see if I go over any of the limits. Nothing is anywhere near the max limit (records I checked so far)...

I'm thinking maybe the file size is too large...

I am upgrading to OS 9.1 to see if that helps the hang up problems.

running it on 500mhz dual processor G4 powermac.

-jk

Have you tried allocating more RAM to FMP via Get Info?

Yup...

I will just break the data into smaller pieces. THanks all anyway

-J

I have opened databases as big as yours in FoxPro for Macintosh successfully, but have not tried in FMP.

Please tell us the symptoms of "crashing the program". A summary calculation across 460K records may take a VERY long time and give the appearance that the machine is stuck (watch the watch). If the "crash" is a prolonged display of the watch, all is probably proceeding normally.

The only other thing that comes to mind is hard disk space. FileMaker creates temporary files. This temporary file could be as large as the original file. While you should get a warning, it's something to check.

-bd