Hey Bankmann,
I had a similar experience in converting a huge 110 FP5 solution. After investing $6,200 in a FileMaker 7 upgrade, and spending a gruelling 2 weeks in a partial (11 files) migration process, I was heavily disappointed in the sluggish performance. In fact, after a one day test run with only one user, I went back to the original database... I just couldn't subject 35 users to this degradation in performance.
But, the security and relational features are incredible! I am hopeful that perhaps a new Citrix server (our current one is a dual 1 Ghz WIn 2000 Server) may boost the performance enough to go live next week.
All in all, it will probably be about a $10,000 investment in software and hardware to upgrade to FP7... a hefty chunk of change for a non-profit...
On another note, I bought the MetaData Magic package from New Millenium and used the File Reference Fixer on my FP5 databases before the conversion and this made a nice performance increase (compared to the non-fixed conversion). It seems that if the File References aren't fixed first, FP7 spends a bunch of time looking through various file reference options.
See Ya
Joe