David ---
Agreed. The only time I have seen local views slow down is when it's a view with a complex "where" clause or the source table(s) are large and not optimally indexed but even then the lag is small.
>
>I use local views quite extensively, I can't say that they "feel" any slower than raw tables.
>
>>Well it seems I you guys agree. Views should not be used on local data if you want speed. But if you want to help your marketing efforts and ease the conversion to SQL use views. This last one appears to punish the customer if they have large amounts of data and forces them into the expense of SQL.
>>
>>Most of my customers will not be switching to SQL for years if ever. Would it be better to create two (maybe 3) classes to cover how the data is seen???
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05