Re: 答复: 答复: A difficult data model with C*

>* wrote >>> >>> The solution maybe work. However, the play list will grow over time and >>> somebody maybe has ten thousands that will slow down the query and sort . >>> Do you mean the oldest one should be removed when a new play is added? >>> >>> BTW, the ve

Re: 答复: 答复: A difficult data model with C*

that will slow down the query and sort . >> Do you mean the oldest one should be removed when a new play is added? >> >> BTW, the version is 2.1.16 in our live system. >> >> >> BRs, >> >> BEN >> -- >> >>

Re: 答复: 答复: A difficult data model with C*

gt; >>> On Wed, 09 Nov 2016 20:47:05 -0500*Diamond ben >>> >* wrote >>> >>> The solution maybe work. However, the play list will grow over time and >>> somebody maybe has ten thousands that will slow down the query and sort . >>> Do you

Re: 答复: 答复: A difficult data model with C*

list will grow over time and >>> somebody maybe has ten thousands that will slow down the query and sort . >>> Do you mean the oldest one should be removed when a new play is added? >>> >>> BTW, the version is 2.1.16 in our live system. >>> >>> >

Re: 答复: 答复: A difficult data model with C*

removed when a new play is added? >> >> BTW, the version is 2.1.16 in our live system. >> >> >> BRs, >> >> BEN >> -- >> >> *发件人:* Vladimir Yudovin >> *发送时间:* 2016年11月9日 18:11:26 >> *收件人:* user

Re: 答复: 答复: A difficult data model with C*

ten thousands that will slow down the query and sort . > Do you mean the oldest one should be removed when a new play is added? > > BTW, the version is 2.1.16 in our live system. > > > BRs, > > BEN > ------ > > *发件人:* Vladimir Yudovin >

Re: 答复: 答复: A difficult data model with C*

is added? BTW, the version is 2.1.16 in our live system. BRs, BEN 发件人: Vladimir Yudovin <vla...@winguzone.com> 发送时间: 2016年11月9日 18:11:26 收件人: user 主题: Re: 答复: A difficult data model with C* You are welcome! ) >recent ten movies watched by the user within 30 days. In this ca

答复: 答复: A difficult data model with C*

发件人: Vladimir Yudovin 发送时间: 2016年11月9日 18:11:26 收件人: user 主题: Re: 答复: A difficult data model with C* You are welcome! ) >recent ten movies watched by the user within 30 days. In this case you can't use PRIMARY KEY (user_name, video_id), as video_id is demanded to fetch row

Re: 答复: A difficult data model with C*

You are welcome! ) >recent ten movies watched by the user within 30 days. In this case you can't use PRIMARY KEY (user_name, video_id), as video_id is demanded to fetch row, so all this stuff may be CREATE TYPE play (video_id text, position int, last_time timestamp); CREATE TABLE recent (use

答复: A difficult data model with C*

Hi Vladimir Yudovin, Thank you very much for your detailed explaining. Maybe I didn't describe the requirement clearly. The use cases should be: 1. a user login our app. 2. show the recent ten movies watched by the user within 30 days. 3. the user can click any one of the ten movie and co