General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Speed and views vs. SQL Selects
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only