In this case this should also go to cassandra user group. Please post it over there too.
Sent from my BlackBerry -----Original Message----- From: "ec.developer" <[email protected]> Date: Mon, 30 Jul 2012 04:14:21 To: <[email protected]> Cc: <[email protected]> Subject: Re: [nodejs] Slow cassandra reading Thanks for reply. Yes, there is the latest version of Cassandra. The type of contents - is LongType. It also has index type Key. On Monday, July 30, 2012 1:15:32 PM UTC+3, KRISHNA GUDA wrote: > > Which version of cassandra is in place now? I noticed similar behavior in > earlier versions. Is time_add a timeuuid/timestamp and is your key? > However, cassandra can be extremely slow(~million rows) if u didn't have > the right key (cassandra)data type. If you are using varchar, it could take > a minute and it is very much possible that you are getting some wrong > results too. > > // Krishna > Sent from my BlackBerry > ------------------------------ > *From: * "ec.developer" <[email protected]> > *Sender: * [email protected] > *Date: *Mon, 30 Jul 2012 02:59:35 -0700 (PDT) > *To: *<[email protected]> > *ReplyTo: * [email protected] > *Subject: *[nodejs] Slow cassandra reading > > Hi all, > I have a Cassandra DB. I use Helenus module ( > https://github.com/simplereach/helenus) for interracting with it. The > number of records is around 1 million. I query the DB using cql queries. > For queries like "select * from news where title='Sample news'" - > everything goes fine. > But if I add some greater/lesser stuff, such as "select * from news where > time_add > some_timestamp" , this query runs Very Slow (I have to wait up > to few minutes, till I get the result). > > Any hints on how can I solve it? > Thanks > > -- > Job Board: http://jobs.nodejs.org/ > Posting guidelines: > https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines > You received this message because you are subscribed to the Google > Groups "nodejs" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/nodejs?hl=en?hl=en > -- Job Board: http://jobs.nodejs.org/ Posting guidelines: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines You received this message because you are subscribed to the Google Groups "nodejs" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nodejs?hl=en?hl=en
