Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Stored Procedures x Scripts |
Mon, Mar 10 2008 4:57 PM | Permanent Link |
"Jose Eduardo Helminsky" | Tim
I am starting with ElevateDB and have some doubts. I know stored procedures are stored at server side and scripts came from client side and processed by the server but the result of both can be the same ? IOW, the code of both could be the same ? Scripts can be changed in TMemo and send to a server instead of Server load Stored Procedures from database and run it ? What about the speed ? Stored procedures are pre-compiled ? Eduardo |
Tue, Mar 11 2008 4:53 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Eduardo,
<< I am starting with ElevateDB and have some doubts. I know stored procedures are stored at server side and scripts came from client side and processed by the server but the result of both can be the same ? IOW, the code of both could be the same ? >> Yes, they can be exactly the same, except for the minor differences in terms of the starting definition (CREATE PROCEDURE vs. SCRIPT). << Scripts can be changed in TMemo and send to a server instead of Server load Stored Procedures from database and run it ? >> Yes. << What about the speed ? >> The speed is effectively the same, after each has been compiled. << Stored procedures are pre-compiled ? >> Effectively, yes. They are compiled when prepared and kept as such until they are no longer being used. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |