DBStore (session storage) should probably create index on rkey

11 views
Skip to first unread message

laundmo

unread,
Oct 7, 2025, 6:08:33 AM (12 days ago) Oct 7
to py4web
Depending on the expiration, which defaults to "never", this table can grow quite large if a site is used regularly. That makes DBStore.get very slow if the table is large, due to the DB needing to do a full scan when querying for table.rkey == key.
 
To avoid users needing to manually create a index on rkey, the DBStore should probably do this automatically (while not forgetting that the create_index method internally does a commit/rollback).
Reply all
Reply to author
Forward
0 new messages