Restricting access slows finds?
My database has about 500,000 records of contact information for people. I want to restrict access for a user to people in say Massachusetts so I built a privilege set that does this (I will create the "Find" script next to get rid of the <no access> issue) but when I log in with the account that restricts the records the Finds become VERY slow. I do a lot of indexing so typically my finds take less than 5 seconds. But when the records are restricted they take minutes.