Contact: fumanchu@aminus.org

Log in as guest/geniusql to create tickets

Ticket #23 (defect)

Opened 3 years ago

Last modified 3 years ago

ast_to_sql_cache grows infinitely

Status: closed (fixed)

Reported by: guest Assigned to: tabo
Priority: major Milestone:
Component: SQL Version:
Keywords: Cc:
Estimate (total hours):

generated sql queries are cached in this global object, this is problematic when making a lot of unique queries

a well thought out solution would be to keep statistics on each cached object and prune the ones that don't get used often or that are fastest to parse

the easiest solution is to clear the cache one its gets past an arbitrary value, right before storing a new query in the cache

    if len(ast_to_sql_cache) > 4096:
        ast_to_sql_cache.clear()

Change History

02/15/09 13:47:41: Modified by tabo

  • owner changed from fumanchu to tabo.

Fixed in r275.

02/15/09 13:47:59: Modified by tabo

  • status changed from new to closed.
  • resolution set to fixed.