DAV view include the condition in Where clause:" DOMINO.IsReader4(database_name, #NOTEID, #READERS, USER) = 1 "
So, while fetching from DAV_view, the lotus function IsReader is called for each row in table DAV_table_T. It is slow.
Can I fetch the data from DAV table, directly.
It will disable the lotus security check, but in our case, it is not significant