Filemaker 9 Perfomance Question

[Doubledunk]

I am developing a solution for 300,000 records. The record count will then increase 7,000 monthly. My question is, how many records can filemaker handle if it's being hosted on a xserve with mac osx 10.3 (Tiger).

I also have a question on the "perform find[]" function. What kind of algorithm does it use? will the find function take a long time to search through 300,000 records? Please assume the search criteria involves 2-6 text fields.

Thank you for your time, Carlos C.

[AudioFreak]

300,000 records is nothing.

Number of records per table: 64 quadrillion total records over life time of file.

See here.

Michael

[Doubledunk]

Thank you Michael, That sure sums it up for me. Now if I could just know what kind of algorithm the Perform Find[] command uses.

I like to know if it will lag going through 300,000 records in performing a find.

Thanks a bunch, Carlos C.

[AudioFreak]

Doing a search it should not. If you are looping through 300,000 records setting a field it will take a few min but a regular search should be fine. Having Filemaker server host the file will improve search speeds considerably FYI.

Providing there are no Unstored calcs on the layout.

Also you will notice the first seach on a field will generally be the slowest. After Filemaker indexes the field search times improve after that.

hth

Michael

Edited August 28, 2007 by Guest