ReneS
Posts: 225
|
| Posted: 02/22/2008, 4:19 AM |
|
Hi,
As the title says, is there a difference in performance when I use stored procedures to handle the update/insert/delete versus the code in the pages? Any difference in reliability etc.
Can someone give me some pointers?
Thanks,
Rene
|
 |
 |
E43509
Posts: 283
|
| Posted: 02/22/2008, 6:04 AM |
|
I think yes. (and I've seen better performance). Especially on complex sql.
Once you create a stored procedure, the logic is already optimized and parsed and is close to the database.
When you send the sql statement over the wire, you not only have transmission time,but that sql needs to go thru an optimizer.
|
|
|
|
wkempees
|
| Posted: 02/22/2008, 6:25 AM |
|
AND futher to the response, when stored procedure code is correct, then
reliability will be much higher also.
SP's are written to the DB, code remains unchanged, so once ok always ok.
Normaly a DBAdministrators task in larger environments.
Tou call the SP supply the parms and fire and forget.
Walter
"E43509" <E43509@forum.codecharge> schreef in bericht
news:247bed6765c003@news.codecharge.com...
>I think yes. (and I've seen better performance). Especially on complex
>sql.
> Once you create a stored procedure, the logic is already optimized and
> parsed
> and is close to the database.
> When you send the sql statement over the wire, you not only have
> transmission
> time,but that sql needs to go thru an optimizer.
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
