I have the db with 16,000 records on a fm server. I've set it the report up for users to enter the two dates (start and end) and then a paste from index to do a find on the date range and the index paste.

I sat this up maybe perhaps a year or more ago and all has been fine but now there is the slow down in running the reports.

What used to take 2-3 minutes now takes the 6-7 minutes every time and they have notified me of it.

The only change has been the server people have updated to OS X and FM 5.5 but I think that was done before the slowdown has started. Specifically when the report button is clicked the Find dialog box appears with the "processing field Date" and this takes the most of the time, 5 minutes of entire report.

All help appreciated.

nati

This is a bit vague.

Is this OS X for the FMServer or FMP on the client machines, or both, or another mixture :

Are they runnig FMP 5.5 on OS X acting as the database host ?

yes the server is OS X FMP 5.5, the clients are the mixture of FMP 5/5.5 and Windows and Macintosh.