Dear Joseph

I don't think so that only 70000 records will take that much time so that your page will expired, probable there must some other reason.

any way first of all...

Difference is Diffference dear

No matters how much is it !!!

as u are saying 1/100 second then it doesn't makes difference for the user?

But i say its make difference what will happen...

Dear Experts.

Can any one guide me that does this behaviour of performance of the  stored procedure will be same for the simple sql queries.

for example if i write

Select *...

Dear repliers.

Thanks for your reply.

but again there is the problem ! i will write this query in the source code of the VB.net form, which will execute this query in...

I m agreed , If he stores the path of the image  in the data base it would be fast but it will problametic if any one remove that image...

Mr Anil

you had told that "The function of the trigger should insert details of the students in the Remarks Field."

but please tell me that where is the remark field in which table...