DBAPI Paramstyle

woodsplitter at rocketmail.com woodsplitter at rocketmail.com
Sat Mar 26 11:16:35 CET 2005


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.




More information about the Python-list mailing list