finding lots of records!!

[dave2000]

hi there,

I have written a task scheduler here for our real estate business, we have 40 agents and 20 admin staff and the boss wanted a task sceduler so if a property is sold it triggers a lot of tasks to be send to the appropriate agent and admin. I have all the tasks in one 'tasks' database and whoever is logged in at that time i just do a find when they want to view their tasks and only the agents related tasks show up in the list. (reminders for 1,2,34,5 years down the track for example)

My problem is that I am wondering how many records a fmp6 file can hold?? as it will build up quite quickly its been running for a few weeks and already we have thousands of records (its up to about 500kb). Will the find slow down a lot after a while and could it crash if it got to say 100,000 records?? they are only text records displayed in list view. Any advice would be much appreciated as i am only relatively new to filmaker. Also when i delete records the file size doesnt decrease, why is this? thanks for all your help!

Dave

[Ender]

You should be fine until you get over a few hundred thousand records, or several hundred MB. The issues I've experience with large files is they open slower over the network, and there may be delays when creating new records.

If you expect your file to get larger than that, then upgrade to FM7.