Subject | Interaction with the database |
---|---|
Author | The DeerBear |
Post date | 2002-12-21T15:48:07Z |
Hello,
As you had a chance to notice, I'm starting to create stored procs for my FB
database.
My idea was, in fact, to create a set of procedures to use( Insert, Select,
etc ) for
"basics" needs and use SQL directly only when _strictly_ necessary.
To my understanding of the matter, in fact, stored procedures are executed
on the
server and only the results are returned to the client.
So I was thinking that would maybe be faster if, for example, I used a
stored
procedure to make inserts into specific tables, instead of using direct SQL
statements.
Is this approach correct or you can point to other( better ) ways to make
things faster with FB?
TIA
Andrew
As you had a chance to notice, I'm starting to create stored procs for my FB
database.
My idea was, in fact, to create a set of procedures to use( Insert, Select,
etc ) for
"basics" needs and use SQL directly only when _strictly_ necessary.
To my understanding of the matter, in fact, stored procedures are executed
on the
server and only the results are returned to the client.
So I was thinking that would maybe be faster if, for example, I used a
stored
procedure to make inserts into specific tables, instead of using direct SQL
statements.
Is this approach correct or you can point to other( better ) ways to make
things faster with FB?
TIA
Andrew