>>Okay, I see your point. But I'm still biased in favor of using a view *grin*
>
>Me too. For one, SET KEY has the limitation of being restricted to a single order. Unless I create lots of composite indices.
Huh ?
Now lets all grin; did we all evolute to better not have indexes at all ? If so, I should re-think what I'm doing here ;)
One thing I know : any next question at UT about slow responses, we should reply with the question "are you possibly using vieuws ?".
Hilmar, you can't be serious here.
>
>With a view, I can quickly retrieve a subset of data, and then index (done automatically by the framework, e.g., if the user double-clicks on the grid headers).
Never thought of this one. Now please come overhere and implement this on all of our tables usually containing over 1M records. BTW, you'll have the support too; write the helptexts on how convenient this all is, and that it is really better for you, the user.
I guess that I missed more than I ever could expect. Never too old to learn.
;))
Peter
>
>Hilmar.