Problem in view

Dear All


I have five table and each table has 5 lacs record.

i have created a view on that table using union clause.

now, i am calling that view from my code like

select * from myview where name like '%mzy%'

now it take too much time and give memory falult [ paging ]

and application server is hang.

my database server [ ms sql ] are on different server and my application server [ iis ] on different server.

now then i have conver that view to stored procedure and call it form my code.

and it give the result..

but i dont understand what is done with view.

So my question is when and where to use view. and why my application server are hang if database server are different.

view are better then stored procedure or not..

so how view are works..

please guide me as early as possible..

Regards,

Suresh