| Store | Cart

DBAPI Paramstyle

From: woodsplitter@rocketmail.com <wood...@rocketmail.com>
26 Mar 2005 02:16:35 -0800
Tim Roberts wrote:
> In theory, using a paramstyle allows the query to be sent to the SQL> database backend and compiled like a program.  Then, successive uses
of the
> same query can be done by sending just the parameters, instead of
sending
> the entire query string to be parsed and compiled again and again.
This is
> commonly done with large production databases like SQL Server and
Oracle.
> For a complicated query, it can be a significant time savings.>> However, to the best of my knowledge, none of the Python dbabi> implementations actually do that.

kinterbasdb does.

Recent Messages in this Thread
Bob Parnes Mar 24, 2005 01:45 pm
Fredrik Lundh Mar 24, 2005 02:03 pm
Bob Parnes Mar 25, 2005 01:44 pm
Tim Roberts Mar 26, 2005 08:54 am
wood...@rocketmail.com Mar 26, 2005 10:16 am
Scott David Daniels Mar 26, 2005 02:27 pm
Andy Dustman Mar 28, 2005 09:43 pm
Gerhard Haering Mar 28, 2005 10:57 pm
Messages in this thread