Jump to content

New to FM, having probs with LARGE file.


This topic is 8525 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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 smile.gif

Thanks

-J

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • Newbies

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... frown.gif

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 8525 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.