Vidhyakar,
You asked:
is it possible to get huge delay while fetching record on view?
A database view is the result of a [SQL] query.
It can take the database several hours before returning the results of a query.
So the answer to your question is yes, it is possible to get a huge delay while fetching a record on a view.
Good Luck,
Avi.