Change Cache_expire_time to a partial index because we don't need to query rows efficiently where expire_time IS NULL (#305)

ddorian · web-flow · commit 9cd3816333fa · 2024-02-26T15:30:46.000-08:00
diff --git a/diskcache/core.py b/diskcache/core.py
@@ -531,7 +531,7 @@ def __init__(self, directory=None, timeout=60, disk=Disk, **settings):
 
         sql(
             'CREATE INDEX IF NOT EXISTS Cache_expire_time ON'
-            ' Cache (expire_time)'
+            ' Cache (expire_time) WHERE expire_time IS NOT NULL'
         )
 
         query = EVICTION_POLICY[self.eviction_policy]['init']

Original file line number	Diff line number	Diff line change
`@@ -531,7 +531,7 @@ def __init__(self, directory=None, timeout=60, disk=Disk, **settings):`
`531`	`531`
`532`	`532`	`sql(`
`533`	`533`	`'CREATE INDEX IF NOT EXISTS Cache_expire_time ON'`
`534`		`- ' Cache (expire_time)'`
	`534`	`+ ' Cache (expire_time) WHERE expire_time IS NOT NULL'`
`535`	`535`	`)`
`536`	`536`
`537`	`537`	`query = EVICTION_POLICY[self.eviction_policy]['init']`