Cache and logging

sql.log logs only CREATE, DROP, and ALTER table.

INSERTs, UPDATEs and SELECTs are logged one at the time in the db._lastsql string.

To check whether caching is used you can do

db._lastsql=None
rows=db(...).select(...,cache=(cache.ram,60))
if db._lastsql:
    print 'SQL WAS EXECUTED AND RESULT CACHED:',db._lastsql
else:
    print 'SQL WAS NOT EXECUTED, DATA RETRIEVED FROM CACHE'