Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
effect on views
- Thread starter Rottdpogs
- Start date
Mike Lewis
Programmer
Hi Rottdpogs,
The choice between views and direct access (SQL pass-through) won't make a huge difference to performance. SQL pass-through will probably be faster, but only very slightly.
A much more important factor is to design your views or queries so that they return the minimum amount of data each time. If you get that right, you will get a much better performance gain than you will by using SPT rather than views.
Mike
Mike Lewis
Edinburgh, Scotland
The choice between views and direct access (SQL pass-through) won't make a huge difference to performance. SQL pass-through will probably be faster, but only very slightly.
A much more important factor is to design your views or queries so that they return the minimum amount of data each time. If you get that right, you will get a much better performance gain than you will by using SPT rather than views.
Mike
Mike Lewis
Edinburgh, Scotland
- Thread starter
- #3
- Status
Similar threads
