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

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