AnsweredAssumed Answered

Restricting access slows finds?

Question asked by PeterDurant on Jul 6, 2013
Latest reply on Jul 14, 2013 by PeterDurant

Title

Restricting access slows finds?

Post

     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.

     Any ideas?

     Thanks,
     Peter

      

Outcomes