Is there a limit? Just curious.

The same like FM database. Practical limit is the sorting of portal, if used.

In CDML practical limit is 50 rows, then it gets slow.

Well, a FMP database is limited to 2G records (just over 2,000,000,000) so ultimately that's your limit.

I don't want to scroll through that in my whole life once

Hi Vaughan,

>>Well, a FMP database is limited to 2G records (just over 2,000,000,000) >>so ultimately that's your limit.

That' s the maximum filesize, so the maximum amount of records depends on the amount of field * data that's in the records.

So with a database with 1k data /record the amount of record would only be about 2.000.000

That's easy to scroll through in a portal!

Regards,

Ernst.

Ernst

2G (2,147,483,648) is also the max number of records.

Anatoli, if it took 1 second to scroll through each related record in the portal and you did it for 8 hours a day, you'd spend just over 204 years scrolling through them all. You'd need two or three lives.

I'm going to test this and see if it really takes 204 years.

Post the results when you're finished, thanks.

should i tell my grandkid's grandkids to check back for the answer?

you can cut the time down by a factor of ten if you set up a script to scroll down. Maybe automatically send out an email when last row is reached. just make sure you pay your internet bills for 20 years or so...

I'll test if it cuts by a factor of ten, by doing it the original way. then doing it Christian's way.

ROFL

Even if a script can create 1,000 records a second it's still going to take over 23 days (running 24/7) to make the 2,000,000,000 related records in the first place.

These are big numbers.