Subject Speed difference question
Author tomsee7
(As a rough approximation, in % terms will be fine)

Does anyone have an opinion on the likely speed difference between:
1. Calling a stored procedure repeatedly versus
2. Sending an sql statement to be prepared and then executing that repeatedly.

The reason it is being asked is that (2) allows for a system to undergo change(s) more easily/readily, so the performance impact of (1) vs (2) is interesting.

Should there is any difference if the statements were SELECTs rather than INSERT/UPDATE/DELETEs then any views here would be good.