Crazy Slow

[stapes]

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.

[Delta Tango]

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.

[stapes]

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

[Vaughan]

Is the file shared, and how?

[stapes]

No sharing at all.

[xoomaster]

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, 2007 by Guest