mysql select some sort of caching
gagsl-py2 at yahoo.com.ar
Wed Oct 21 05:45:21 CEST 2009
En Tue, 20 Oct 2009 23:41:10 -0300, David Sfiligoi <sfiligoi at gmail.com>
> whatever prior date I put in the table's last task date colum somehow
> they are not seen by the SELECT query
> sqlcur.execute("SELECT `url`d` from `url_snapshot` WHERE `url` = %s and
> `lastsnapshotdate` < %s",(url,currentdate))
> that query returns old data.
> Just like if the query is cached....yet the data actually changed in the
If you want to keep the cursor open, you must commit the (implicit)
current transaction, even if it only contains selects (a rollback would
Alternatively, lower the transaction isolation level below "repeatable
reads". Note that in other scenarios, ensuring that the same query returns
the same results is a Good Thing.
More information about the Python-list