hi all. i wonder what is better between used store procedure for update and use normal where update. my friend told me that if we use update sql state in vb, it is slower than store procedure.

'vb update
for example: con.execute "update tblstudent set score=100 where studentid=1"

'and procedure update
'con.execute "st_student....."

____________________________
Please help out.

Hi,
Your friend is quite correct.  In simple terms, any SQL statement needs to be checked by the database engine (SQL-Server / MySQL) before being executed, but if the procedure has been stored then that means that it has already been checked and optimized for execution - which means that one step of the process does not need to take place so it all happens more quickly!


____________________________
multi-tasking - the ability to hang more than one app. at the same time.

Your friend is truly right. But I will advise you leave the use of stored procedures for those query you will have to execute several times. This is because stored procedures are slower at their first execution because they are being compiled before execution. Subsequent executions will then be faster because compilation will no longer be done, just straight execution.