On May 9, 2007, at 4:36 AM, Ashish Karalkar wrote:
Thanks All for your replies,
But then dont we have any disadvantage of using View???
With Reagrds
Ashish...
I once inherited a database that made extensive use of constants in views (a la magic numbers) as well as had several instances of complex views referencing other complex views. The magic numbers made it extremely difficult at first understand what was going on with the entire application (both on server and client) because it appeared that I was getting values out of thin air that were not coming from any tables or the client. The views-referencing-other-views made changing a view several layers up in the dependency hierarchy a real PITA as I had to completely drop all the views and re-add them.
Views are powerful, but with great power comes great responsibility. They can be very easily abused IMHO.
--
Ilan Volow
Implicit code is inherently evil, and here's the reason why: