Maximum amount of records

[davepain]

Does Filemaker have a limit to the quantity of records it can handle, seems to import them all from ODBC but strange things are now happening 155K records, or does this depend more on my system memory etc?

[Lee Smith]

Hi Dave,

Does Filemaker have a limit to the quantity of records it can handle, seems to import them all from ODBC but strange things are now happening 155K records ...

There is a maximum 2 Gigs for the files, but none for the size of each records. I'm not familar with ODBC workings, but a file only 155 megs shouldn't have any effect on things.

... or does this depend more on my system memory etc?

According to what I have been able to find out, FileMaker only needs about 40 megs RAM for v6 and below, anything else is a waste. If I remember correctly, it was broken down as about 8 megs for the program and 30 megs for the files.

HTH

Lee

[Wim Decorte]

No, FileMaker has a file size limit (2 GB for FM6, 8 TB for FM7). The # of records depends on the amount of data in any one record.

You're importing from an ODBC source? Do you have any calcualtion or summary fields? They might trigger or recalculate for every new record that comes in which can slow your machine down incrementally.

How much RAM do you have?

[transpower]

FM6: 100 million records/file

FM7: 64 quadrillion records/file over the life-time of the file

These are the theoretical limits. When you get to 64 quadrillion records, please notify this forum....

[Lee Smith]

FM6: 100 million records/file .. -snip-

Where did you get this information? Is it New!

I have participated in several FileMaker lists, for more years than I care to admit, and when this question has come up in the past, the answer has always been what I posted earlier. If this isn't brand new information, then it seems funny that noted experts such as, Jimmy Jones, who participate in many of these lists, haven't mentioned it before.

Lee

[transpower]

Lee:

Source: p. 21 in Using FileMaker 7.