I've got a very small database (1000 records or so) with about 50 scripts. In list view, when I move from record to record I get an hour glass with each move time. Likewise the running of any script. I'm mean its wicked slow. I'm running on a dual boot machine, xp on both sides, but I haven't upgraded one side to 9 from 8.5. On the 8.5 side its as fast as a scalded dog. Anyone else having this problem? Any help appreciated.

Several factors could be at work. Does your table have lots of fields? Are they complicated calculations?

You might try indexing whatever fields you can.

no...only 35 fields, no heavy duty calculations. I posted here because I thought it might be something in 9 - when running the same database in 8.5 its pretty snappy. Thanks for your reply tango - all help appreciated

Is the file shared, and how?

No sharing at all.

Consider reviewing your Relationships. There has been some changes in FMP 9 . I had noted that with a few of my tables. Minor tweaking often resolves the issues.

Edited October 8, 200718 yr by Guest