Are you using local views or are you using the tables directly? If so, make sure the NoDataOnLoad option is selected and you are using view parameters to get just the records the user requries.

Do you have an index on DELETED() for one of the large tables? If so, you might want to get rid of it.

CTBlankenship

South Hadley huh? My friend, Brian MacLaflin is a firefighter there. I'm wearing the South Hadley District One fire fighter shirt that he gave me today. Go figger.