11 Replies Latest reply on Jul 14, 2013 4:44 AM by PeterDurant

    Restricting access slows finds?

    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