In the recent "Slow multiple user access" thread there was a discussion about speed when using views, updateable views or SQL Selects to retrieve data. What IS the accepted wisdom on this - in the context of an NT or peer-to-peer network... i.e.:

- does using non-updateable views slow down retrieving the data?

- I have an updateable view that is used in one form to actually update entries (typically 1-30 records); if not performing any updates are there speed considerations in using this same view in another form to display data?

- I've become a convert to views, but maybe I've gone overboard in their use. For instance, when displaying hundres/thousands of records in a grid, with child information in related grids...is it better to just use basic SQL statements or a view?

TIA. J