| Subject | Speed difference question |
|---|---|
| Author | tomsee7 |
| Post date | 2009-11-27T17:59:01Z |
(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.
Tom
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.
Tom