[issue12993] prepared statements in sqlite3 module

[Mayur & Angela Patel-Lam]

Mayur & Angela Patel-Lam <patel.lam.fam...@gmail.com> added the comment:

Okay, I missed that in the documentation.  I was looking for a handle to a
prepared statement.  I suppose it's hashing on the text of the SQL statement
to determine equivalence?

I'm willing to retract the request.  I need to restructure my code a little
bit to take advantage of this feature.

On Sat, Sep 17, 2011 at 5:47 PM, poq <rep...@bugs.python.org> wrote:

>
> poq <p...@gmx.com> added the comment:
>
> The sqlite3 module already uses prepared statements. Quoting from the
> documentation:
>
> "The sqlite3 module internally uses a statement cache to avoid SQL parsing
> overhead. If you want to explicitly set the number of statements that are
> cached for the connection, you can set the cached_statements parameter. The
> currently implemented default is to cache 100 statements."
>
> ----------
> nosy: +poq
>
> _______________________________________
> Python tracker <rep...@bugs.python.org>
> <http://bugs.python.org/issue12993>
> _______________________________________
>

----------
Added file: http://bugs.python.org/file23207/unnamed

_______________________________________
Python tracker <rep...@bugs.python.org>
<http://bugs.python.org/issue12993>
_______________________________________
Okay, I missed that in the documentation.  I was looking for a handle to a 
prepared statement.  I suppose it&#39;s hashing on the text of the SQL 
statement to determine equivalence?<br><br>I&#39;m willing to retract the 
request.  I need to restructure my code a little bit to take advantage of this 
feature.<br>
<br><br><br><div class="gmail_quote">On Sat, Sep 17, 2011 at 5:47 PM, poq <span 
dir="ltr">&lt;<a 
href="mailto:rep...@bugs.python.org";>rep...@bugs.python.org</a>&gt;</span> 
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 
.8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
poq &lt;<a href="mailto:p...@gmx.com";>p...@gmx.com</a>&gt; added the 
comment:<br>
<br>
The sqlite3 module already uses prepared statements. Quoting from the 
documentation:<br>
<br>
&quot;The sqlite3 module internally uses a statement cache to avoid SQL parsing 
overhead. If you want to explicitly set the number of statements that are 
cached for the connection, you can set the cached_statements parameter. The 
currently implemented default is to cache 100 statements.&quot;<br>

<br>
----------<br>
nosy: +poq<br>
<div><div></div><div class="h5"><br>
_______________________________________<br>
Python tracker &lt;<a 
href="mailto:rep...@bugs.python.org";>rep...@bugs.python.org</a>&gt;<br>
&lt;<a href="http://bugs.python.org/issue12993"; 
target="_blank">http://bugs.python.org/issue12993</a>&gt;<br>
_______________________________________<br>
</div></div></blockquote></div><br>

_______________________________________________
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com