Hi,

I need to build to a customer of mine a simple billing database.

He gets max up to 1,000,000 records per month.

So lets say we keep records for the last 2-3 years with something like 20,000,000 records.

Most of the fields (20) will be non-calc.

My question is, can FMP8 handle it? how would be the performance? did anyone try it?

Can anyone suggest a good schema?

My intentions where for each box (Sending CDRs) create a table.

But I don't know if to create them all in the same file or to seperate it...

Any comment will be appreciated.

P.S

I can use MySql/Radius, but I'm an FMP junky...

My biggest is 3 Mil records, takes quite a while to build any Indexes, (so only index files you absolutley need to), after that it runs just fine.

20 Mil, I don't know, you might just try and create a test file and give it a quick shot.

I have a file with about 40+ million records, which works fine after all needed indexing is done, but indexes can take overnight runs...