Re: Advice on a design

2011-03-03 Thread Jeremy Hanna
Have you considered using Solandra (Solr/Lucene + Cassandra) - https://github.com/tjake/Lucandra#readme ? There is a #solandra channel on freenode if you had any questions as well. On Mar 3, 2011, at 8:00 AM, Vodnok wrote: > Ok seems that i'll use Solr (with dedicated Cassandra) for search >

Re: Advice on a design

2011-03-03 Thread Vodnok
Ok seems that i'll use Solr (with dedicated Cassandra) for search I've readed this article : http://ria101.wordpress.com/2010/02/22/cassandra-randompartitioner-vs-orderpreservingpartitioner/ on RP vs OPP... Here is my case docs_shared{ //docs shared by users ordered by time 'time:id_user:i

Re: Advice on a design

2011-03-03 Thread Vodnok
Ok seems that i'll use Solr (with dedicated Cassandra) for search I've readed this article : http://ria101.wordpress.com/2010/02/22/cassandra-randompartitioner-vs-orderpreservingpartitioner/on RP vs OPP... Here is my case docs_shared{ //docs shared by users ordered by time 'time:id_user:id

Re: Advice on a design

2011-03-02 Thread Burc Sade
You can use PHP Solr Extension. It is a fully featured and light-weight client. http://www.php.net/manual/en/book.solr.php Without the secondary indexes on columns in CFs within SCFs, the best approach is to create query-specific CFs at the moment. In the end all comes down to how simple you can

Re: Advice on a design

2011-03-02 Thread Vodnok
I think too via Solr it'll be easier. Just need to google it. (if you have links about Solr in php...) I realize that i have to remove some dimension to my CF... I thought it was possible to have SCF -> CF -> SC -> C:value having secondary index on C but has i understood, secondary index on C on

Re: Advice on a design

2011-03-01 Thread Burc Sade
Hi Vodnok, For tag searches I would use a search engine like Solr (Lucene), as I think it would be more flexible to query. You can update the index as new data comes in and query it for queries #1, #2 and #4. For "All doc of type='BOT' and c_bot_code='ABC'" query, I would create the CF below. do