>>>
>>>Bruce,
>>> the idea behind views is to save network traffic- by retrieving only
>the
>>>subset needed from the server
>>>big views kind of goes against that concept in the first place
>>>
>>That's pretty much what I was thinking...I've been in the habit of
>>categorically using/recommending views for many situations without really
>>considering size they may reach...but I'm going to give it more attention
>>in the future...
>
>for creating semi-incremental search based on views
>I set a treshhold (e.g 5 letters etc.) only after which the view get
>queried (and requeried)
>ie only when a small enough subset will be retrieved
>
That's a good idea...I do a similar thing with cursor/queries off of very large tables to limit the size, so we don't "break the bank" (s)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.