Re: Specifying row caching on per query basis ?

2011-02-09 Thread buddhasystem

Jonathan, what if the data is really homogeneous, but over a long period of
time. I decided that the users who hit the database for recent past should
have a better ride. Splitting into a separate CF also has costs, right?

In fact, if I were to go this way, do you think I can crank down the key
caches? If yes, down to what level, zero?

Thanks!



Jonathan Ellis-3 wrote:
> 
> Not really, no.  If you can't trust LRU to cache the hottest rows
> perhaps you should split the data into different ColumnFamilies.
> 
> On Wed, Feb 9, 2011 at 1:43 PM, Ertio Lew  wrote:
>> Is this under consideration for future releases ? or being thought
>> about!?
>>
>>
>>
>> On Thu, Feb 10, 2011 at 12:56 AM, Jonathan Ellis 
>> wrote:
>>> Currently there is not.
>>>
>>> On Wed, Feb 9, 2011 at 12:04 PM, Ertio Lew  wrote:
>>>> Is there any way to specify on per query basis(like we specify the
>>>> Consistency level), what rows be cached while you're reading them,
>>>> from a row_cache enabled CF. I believe, this could lead to much more
>>>> efficient use of the cache space!!( if you use same data for different
>>>> features/ parts in your application which have different caching
>>>> needs).
>>>>
>>>
>>>
>>>
>>> --
>>> Jonathan Ellis
>>> Project Chair, Apache Cassandra
>>> co-founder of DataStax, the source for professional Cassandra support
>>> http://www.datastax.com
>>>
>>
> 
> 
> 
> -- 
> Jonathan Ellis
> Project Chair, Apache Cassandra
> co-founder of DataStax, the source for professional Cassandra support
> http://www.datastax.com
> 
> 

-- 
View this message in context: 
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Specifying-row-caching-on-per-query-basis-tp6008838p6009462.html
Sent from the cassandra-u...@incubator.apache.org mailing list archive at 
Nabble.com.


Re: Specifying row caching on per query basis ?

2011-02-09 Thread Edward Capriolo
On Wed, Feb 9, 2011 at 2:43 PM, Ertio Lew  wrote:
> Is this under consideration for future releases ? or being thought about!?
>
>
>
> On Thu, Feb 10, 2011 at 12:56 AM, Jonathan Ellis  wrote:
>> Currently there is not.
>>
>> On Wed, Feb 9, 2011 at 12:04 PM, Ertio Lew  wrote:
>>> Is there any way to specify on per query basis(like we specify the
>>> Consistency level), what rows be cached while you're reading them,
>>> from a row_cache enabled CF. I believe, this could lead to much more
>>> efficient use of the cache space!!( if you use same data for different
>>> features/ parts in your application which have different caching
>>> needs).
>>>
>>
>>
>>
>> --
>> Jonathan Ellis
>> Project Chair, Apache Cassandra
>> co-founder of DataStax, the source for professional Cassandra support
>> http://www.datastax.com
>>
>

I have mentioned a suggested implemented inside this issue.

https://issues.apache.org/jira/browse/CASSANDRA-2035


Re: Specifying row caching on per query basis ?

2011-02-09 Thread Jonathan Ellis
Not really, no.  If you can't trust LRU to cache the hottest rows
perhaps you should split the data into different ColumnFamilies.

On Wed, Feb 9, 2011 at 1:43 PM, Ertio Lew  wrote:
> Is this under consideration for future releases ? or being thought about!?
>
>
>
> On Thu, Feb 10, 2011 at 12:56 AM, Jonathan Ellis  wrote:
>> Currently there is not.
>>
>> On Wed, Feb 9, 2011 at 12:04 PM, Ertio Lew  wrote:
>>> Is there any way to specify on per query basis(like we specify the
>>> Consistency level), what rows be cached while you're reading them,
>>> from a row_cache enabled CF. I believe, this could lead to much more
>>> efficient use of the cache space!!( if you use same data for different
>>> features/ parts in your application which have different caching
>>> needs).
>>>
>>
>>
>>
>> --
>> Jonathan Ellis
>> Project Chair, Apache Cassandra
>> co-founder of DataStax, the source for professional Cassandra support
>> http://www.datastax.com
>>
>



-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com


Re: Specifying row caching on per query basis ?

2011-02-09 Thread Ertio Lew
Is this under consideration for future releases ? or being thought about!?



On Thu, Feb 10, 2011 at 12:56 AM, Jonathan Ellis  wrote:
> Currently there is not.
>
> On Wed, Feb 9, 2011 at 12:04 PM, Ertio Lew  wrote:
>> Is there any way to specify on per query basis(like we specify the
>> Consistency level), what rows be cached while you're reading them,
>> from a row_cache enabled CF. I believe, this could lead to much more
>> efficient use of the cache space!!( if you use same data for different
>> features/ parts in your application which have different caching
>> needs).
>>
>
>
>
> --
> Jonathan Ellis
> Project Chair, Apache Cassandra
> co-founder of DataStax, the source for professional Cassandra support
> http://www.datastax.com
>


Re: Specifying row caching on per query basis ?

2011-02-09 Thread Jonathan Ellis
Currently there is not.

On Wed, Feb 9, 2011 at 12:04 PM, Ertio Lew  wrote:
> Is there any way to specify on per query basis(like we specify the
> Consistency level), what rows be cached while you're reading them,
> from a row_cache enabled CF. I believe, this could lead to much more
> efficient use of the cache space!!( if you use same data for different
> features/ parts in your application which have different caching
> needs).
>



-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com


Specifying row caching on per query basis ?

2011-02-09 Thread Ertio Lew
Is there any way to specify on per query basis(like we specify the
Consistency level), what rows be cached while you're reading them,
from a row_cache enabled CF. I believe, this could lead to much more
efficient use of the cache space!!( if you use same data for different
features/ parts in your application which have different caching
needs).