I have a sql select query which takes about 20 seconds, I want to use mysql cache to cache result so I can quickly get results.
After doing some configuration in my.cnf, I succeed achieving this when run select query in Linux mysql client console. the added lines in my.cnf is: query_cache_size = 268435456 query_cache_type = 1 query_cache_limit = 1048576 But when I run the query from web.py code. The cache function seems not working, that is, the execution time is not shorter than before. Below is the web.py code: import web db = web.database(dbn='mysql', db='RLCM', user='guest', pw='guest') sql = "SELECT xxx from xx" results = db.query(sql); Do I need to add any parameters to enable cache? -- You received this message because you are subscribed to the Google Groups "web.py" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/webpy. For more options, visit https://groups.google.com/d/optout.
