>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 think, the slowing down of data retrieval is not caused by the view processes, but obviously, it is the usage of PC resources if opening the forms simultaneously. While saying this, I haven't seen significant change whether it slows down or not.
>- I've become a convert to views, but maybe I've gone overboard in their use.
We do the same but we are into Remote Views for scalability purposes.
>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?
If for displaying data and updating of records with no pain, we are using views. SQL Pass Through will only come into play - at least in our case - if we directly manipulate data and execution of Stored Procedures.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."