How many rows can a portal have?

[Jason Mundok]

Is there a limit? Just curious.

[Anatoli]

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.

[Vaughan]

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

[Anatoli]

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

[ernst]

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.

[Vaughan]

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.

[paulage77]

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

[Vaughan]

Post the results when you're finished, thanks.

[veganboyjosh]

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

[cjaeger]

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

[paulage77]

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

[Anatoli]

ROFL

[Vaughan]

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.