yes, is the same table, my mistake.
On Mon, Sep 1, 2014 at 6:35 PM, Laing, Michael [via cassandra-u...@incubator.apache.org] < ml-node+s3065146n7596569...@n2.nabble.com> wrote: > Is table track_user equivalent to table userpixel? > > On Monday, September 1, 2014, Eduardo Cusa <[hidden email] > <http://user/SendEmail.jtp?type=node&node=7596569&i=0>> wrote: > >> Hi All. I Have a Cluster in Amazon with the following settings: >> >> * 2 Nodes M3.Large >> * Cassandra 2.0.7 >> * Default instaltion on ubuntu >> >> And I have one table with 5.000.000 rows: >> >> >> CREATE TABLE track_user ( userid text, trackid text,date text ,advid >> text, country text, region text, >> PRIMARY KEY( (trackid,advid , country, >> region),userid )); >> >> >> When run the following query take *20 **seconds * to finish : >> >> cqlsh:usmc> select count(*) from userpixel where trackid = 'ab1' and >> advid = 'adb1' and country = 'AR' and region = 'C' limit 5000000; >> >> >> Is this time normal? >> >> There are any way to improve the response? >> >> >> Thanks >> Eduardo >> > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/EC2-Performace-Question-tp7596568p7596569.html > To start a new topic under cassandra-u...@incubator.apache.org, email > ml-node+s3065146n3065146...@n2.nabble.com > To unsubscribe from cassandra-u...@incubator.apache.org, click here > <http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3065146&code=ZWR1YXJkby5jdXNhQHVzbWVkaWFjb25zdWx0aW5nLmNvbXwzMDY1MTQ2fC04NTYyNzA1NQ==> > . > NAML > <http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/EC2-Performace-Question-tp7596568p7596570.html Sent from the cassandra-u...@incubator.apache.org mailing list archive at Nabble.com.
