For any website just starting out, the load initially is minimal & grows
with a slow pace initially. People usually start with their MySQL based
sites with a single server(***that too a VPS not a dedicated server)
running as both app server as well as DB server & usually get too far with
this setu
What about if I spread these columns across 20 rows ? Then I have to
query each of these 20 rows for 500 columns. but still this seems a
better solution than one row for all cols or separate row for each
email id approaches !?
On Fri, Jul 27, 2012 at 11:36 AM, Aklin_81 wrote:
> Sorry for
Sorry for the confusion created. I need to store emails registered
just for a single application. So although my data model would fit
into just a single row. But is storing a hundred million columns(col
name size= 8 byte; col value size=4 byte ) in a single row a good idea
? I am very much tempted
Hmm .. it would be great if the supercolumns API remains. Also I
believe we can replace the full functionality of supercolumns through
composite column names in case this issue (related to reading multiple
column ranges) is
resolved:https://issues.apache.org/jira/browse/CASSANDRA-2710
On Sun, Jan
th ~30 small columns
> per SC some time back and I think we ended up with SCs being 10-20% faster.
>
>
> Terje
>
> On Jan 5, 2012, at 2:37 PM, Aklin_81 wrote:
>
>> I have seen supercolumns usage been discouraged most of the times.
>> However sometimes the supe
Any comments please ?
On Thu, Jan 5, 2012 at 11:07 AM, Aklin_81 wrote:
> I have seen supercolumns usage been discouraged most of the times.
> However sometimes the supercolumns seem to fit the scenario most
> appropriately not only in terms of how the data is stored but also in
> ter
I have seen supercolumns usage been discouraged most of the times.
However sometimes the supercolumns seem to fit the scenario most
appropriately not only in terms of how the data is stored but also in
terms of how is it retrieved. Some of the queries supported by SCs are
uniquely capable of doing
I need to create mapping from (s) to (s) which need to
provide for fast lookups service ?
Also I need to provide a mapping from to inorder to
implement search functionality in my application.
What could be a good strategy to implement this ? (I would welcome
suggestions to use any new technologi
Is there a way to configure the serializers to use while showing up the
stored data ??
Thanks
Aklin
On Tue, Nov 1, 2011 at 5:02 PM, Aditya Narayan wrote:
> Yes that would be pretty nice feature to see!
>
>
>
> On Mon, Oct 31, 2011 at 10:45 PM, Ertio Lew wrote:
>
>> Thanks so much SebWajam fo
anyone who can share what is the most recommended way of doing this
On Sat, Feb 19, 2011 at 7:12 PM, Aklin_81 wrote:
> Is there a way to just ask for column names in a row to get just a
> column names list (and not the entire >). I am
> using Hector.
>
> I have a row of valuel
Is there a way to just ask for column names in a row to get just a
column names list (and not the entire >). I am
using Hector.
I have a row of valueless columns (whose column names are keys to
another set of rows) & I wish to retrieve a list of those column names
and send it in another query to r
one ?
On Fri, Feb 18, 2011 at 10:32 PM, Aklin_81 wrote:
>
> Sylvain,
> I also need to store data that is frequently updated, same column being
> updated several times during each user session, at each action by user, But,
> this data is not very fresh and hence when I update thi
he sstables and reclaim the
> space (eventually) ?
>
>
> james
>
> On 18 Feb 2011, at 08:36, Sylvain Lebresne wrote:
>
> On Fri, Feb 18, 2011 at 8:14 AM, Aklin_81 wrote:
>
>> Are the very freshly written columns to a row in memtables, efficiently
>> update
Are the very freshly written columns to a row in memtables, efficiently
updated/overwritten by edited/new column values.
After flushing of memtable, are those(edited + unedited ones) columns stored
together on disk (in same blocks!?) as if they were written in one single
operation or same time ??
I would like to text search for some of Entities/items stored in the
database through an AJAX powered application...Such that the user
starts typing and he can get the hints & suggested items. This is
implemented in SQL databases using the LIKE, is it possible to anyhow
implement this in an applica
I think it does not deserialize the entire list of columns in the
row(though it is the case with subcolumns in a supercolumn). In case
of standard columns, only the blocks on the disk containing the
columns values of the columns being asked for, are read and
deserailized to get the values.
On Sat,
Would be interested in your findings, Patrik! ...
I too was searching for something similar a few days back.. for column
names that contained userIds of users on my application. UUIDs that
seemed to be most widely recognized(perhaps!) solution are 16 bytes
but those definitely seem like a too muc
e in the config.
>
> Aaron
>
>
> On 9/02/2011, at 5:16 AM, Aklin_81 wrote:
>
>> Amongst two rows, where I need to find the common columns. I will not
>> have more than 200 columns(in 99% cases) for the 1st row. But the 2nd
>> row where I need to find these columns
d row ??
Is there any better way ?
Asil
>
> On Feb 7, 2011, at 12:30 AM, Aklin_81 wrote:
>
>> Thanks Aaron & Shaun,
>>
>> **
>> I think my question might have been unclear to some of you. So I would
>> again explain my pr
>> The other alternative is to pull back more data that you need and the
>> intersection in code in the client.
>>
>>
>> Hope that helps.
>> Aaron
>> On 7/02/2011, at 7:11 AM, Aklin_81 wrote:
>>
>>> Hi,
>>>
>>> @buddhasy
Hi,
@buddhasystem : yes that's well known solution. But obviously when
mysql couldnt satisfy my needs, I am here. My question is in context
of Cassandra, if it possible to achieve intersection result set of
columns in two rows, by the way I spoke about.
@Edward: yes that I know but how does that
Hi all,
I want to procure the intersection of columns set of two rows (from 2
different column families).
To achieve the intersection results, Can I, first retrieve all
columns(around 300) from first row and just query by those column
names in the second row(which contains maximum 100 000 columns
mapping in MyISAM as
this data would be required after almost all queries to the database.
Regards
-Asil
On Fri, Feb 4, 2011 at 10:14 PM, Ryan King wrote:
> On Thu, Feb 3, 2011 at 9:12 PM, Aklin_81 wrote:
>> Thanks Matthew & Ryan,
>>
>> The main inspiration beh
for some reason, I
>> would save yourself the headache of this kind of complexity and just use
>> UUIDs if you have to generate an identifier.
>>
>> On Feb 3, 2011, at 2:03 PM, Aklin_81 wrote:
>>
>>> Hi all,
>>> To generate new keys/ UserIds for new u
Hi all,
To generate new keys/ UserIds for new users on my application, I am
thinking of using a simple synchronized counter that can keep track of
the no. of users registered on my application and when a new user
signs up, he can be allotted the next available id.
Since Cassandra is eventually co
including the
timeUUIDType key (that would be helpful in my case) with Random
partition.
On 1/14/11, Roshan Dawrani wrote:
> On Fri, Jan 14, 2011 at 8:51 PM, Aklin_81 wrote:
>
>> I just read that cassandra internally creates a md5 hash that is used
>> for distributing the load
s that of any concern to you?
>
> Are you expecting any storage relationship between column names of CF_B and
> rows of CF_A?
>
> rgds,
> Roshan
>
> On Fri, Jan 14, 2011 at 7:58 PM, Aklin_81 wrote:
>
>> I too believed so! but not totally sure.
>>
>> On 1/1
e... I am not sure anyways...
>
> On Fri, Jan 14, 2011 at 7:18 PM, Roshan Dawrani
> wrote:
>
>> On Fri, Jan 14, 2011 at 7:15 PM, Aklin_81 wrote:
>>
>>> @Roshan
>>> Yes, I thought about that, but then I wouldn't be able to use the
>>> Random Part
lt;http://wiki.apache.org/cassandra/CassandraLimitations>- If you are using
>> cassandra 0.7, have you looked at the secondary indexes ?
>> http://www.riptano.com/blog/whats-new-cassandra-07-secondary-indexes
>>
>> <http://www.riptano.com/blog/whats-new-cassandra-07-
I would like to keep the reference of other rows as names of super
column and sort those super columns according to time.
Is there any way I could implement that ?
Thanks in advance!
the timeline since you're using the same UUID for the column
> name).
>
> If you want to be able to support per-topic timelines for each user, I
> suggest you use one row for each topic that a user is interested in and one
> row for the all-topics timeline. Since you are already
with the topics
user is following, if they match then show the post. But this will ofcourse
increase the pressure during reads, which should better have been towards
writes.
Please suggest any better way that you could think of..
Thanks
On Mon, Jan 10, 2011 at 12:11 AM, Aklin_81 wrote:
> I
I am working on a project of Questions & Answers website that allows a user
to follow questions on certain topics from his network.
I want to build user's news-feed wall that comprises of only those questions
that have been posted by his connections and tagged on the topics that he is
following(hi
33 matches
Mail list logo
