>>>>2. SQL pass-through is a little bit faster. In my experience, a properly configured view is almost as fast, so it's not a huge issue.
>>>>
>>>
>>>Since a View IS a SPT the speed should be about the same.
>>>
>>
>>In our experience the difference in speed can be dramatic, particularly for complex views involving large tables.
>>
>
>I found that to be true when I initially stared working with views, but then I discovered the FetchSize setting. In a view, this defaults to 100 which means if a view returns more than 100 records, VFP will get the first 100 then asynchronously get the rest in batches of 100. If your view returns a couple of thousand records this is much slower than just retrieving everything at once (FetchSize=-1). Once we made the change we saw little difference between views and SPT.
Well. You learn something new every day. Gonna try that.
Thanks -
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
