AFAIK 2nd index only works for operator EQ. -----邮件原件----- 发件人: Kallin Nagelberg [mailto:[email protected]] 发送时间: 2011年2月9日 3:36 收件人: [email protected] 主题: Re: time to live rows
I'm thinking if this row expiry notion doesn't pan out then I might create a 'lastAccessed' column with a secondary index (i think that's right) on it. Then I can periodically run a query to find all lastAccessed columns less than a certain value and manually delete them. Sound reasonable? -Kal
