Whenever we build a Domino Access View (DAV) and run it we get a delay saying the view index is being updated. We also noticed that this happens before executing the SQL Query. As a result, opening of the view can sometimes take longer than a regular notes view.
We don’t quite understand this. Why will it need to do such a thing if the SQL query being executed is suppose to return filtered dataset? We decided to implement DAV to make our application execute view lookups quicker…
We are mirroring much of our DAV with existing regular notes views in the application.
Have anyone else experienced this? or is there something that we are missing on doing to prevent this?
Thanks in advance - Carl