From user-return-36333-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Tue Sep 3 21:16:16 2013 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 462121019F for ; Tue, 3 Sep 2013 21:16:16 +0000 (UTC) Received: (qmail 90791 invoked by uid 500); 3 Sep 2013 21:16:13 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 90759 invoked by uid 500); 3 Sep 2013 21:16:13 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 90751 invoked by uid 99); 3 Sep 2013 21:16:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Sep 2013 21:16:13 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of baskar.duraikannu@outlook.com designates 65.54.190.148 as permitted sender) Received: from [65.54.190.148] (HELO bay0-omc3-s10.bay0.hotmail.com) (65.54.190.148) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Sep 2013 21:16:09 +0000 Received: from BAY169-W136 ([65.54.190.188]) by bay0-omc3-s10.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Tue, 3 Sep 2013 14:15:48 -0700 X-TMN: [/k9hJKaGTh1u9ty7wKfMRacIC9dW77BP] X-Originating-Email: [baskar.duraikannu@outlook.com] Message-ID: Content-Type: multipart/alternative; boundary="_1e04ba6f-d67e-4834-ab3f-f8c637993dff_" From: Baskar Duraikannu To: "user@cassandra.apache.org" Subject: RE: List retrieve performance Date: Tue, 3 Sep 2013 17:15:48 -0400 Importance: Normal In-Reply-To: References: MIME-Version: 1.0 X-OriginalArrivalTime: 03 Sep 2013 21:15:48.0473 (UTC) FILETIME=[C2D2C690:01CEA8EA] X-Virus-Checked: Checked by ClamAV on apache.org --_1e04ba6f-d67e-4834-ab3f-f8c637993dff_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I don't know of any. I would check the size of LIST. If it is taking long= =2C it could be just that disk read is taking long. =20 Date: Sat=2C 31 Aug 2013 16:35:22 -0300 Subject: List retrieve performance From: savio.teles@lupa.inf.ufg.br To: user@cassandra.apache.org I have a column family with this conf: CREATE TABLE geoms ( geom_key text PRIMARY KEY=2C part_geom list=2C the_geom text ) WITH bloom_filter_fp_chance=3D0.010000 AND =0A= caching=3D'KEYS_ONLY' AND comment=3D'' AND dclocal_read_repair_chance=3D0.000000 AND gc_grace_seconds=3D864000 AND read_repair_chance=3D0.100000 AND replicate_on_write=3D'true' AND =0A= populate_io_cache_on_flush=3D'false' AND compaction=3D{'class': 'SizeTieredCompactionStrategy'} AND compression=3D{'sstable_compression': 'SnappyCompressor'}=3B =0A= I run this query "select geom_key=2C the_geom=2C part_geom from geoms limi= t 1=3B" in 700ms. When I run the same query without part_geom attr (select geom_key=2C the_ge= om from geoms limit 1=3B)=2C the query runs in 5 ms.=20 =0A= Is there a performance problem with a List attribute? Thanks in advance =0A= --=20 Atenciosamente=2C S=E1vio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles =0A= =0A= =0A= Mestrando em Ci=EAncias da Computa=E7=E3o - UFG=20 Arquiteto de Software Laboratory for Ubiquitous and Pervasive Applications (LUPA) - UFG=0A= = --_1e04ba6f-d67e-4834-ab3f-f8c637993dff_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I don't know of any. I would che= ck the size of LIST. If it is taking long=2C it could be just that disk rea= d is taking long.  =3B


Date: Sat=2C= 31 Aug 2013 16:35:22 -0300
Subject: List<=3Bblob>=3B retrieve perfo= rmance
From: savio.teles@lupa.inf.ufg.br
To: user@cassandra.apache.or= g

I have a column family with this conf:<= br>
CREATE TABLE geoms (
 =3B geom_key text PRIMARY KEY=2C
&nb= sp=3B part_geom list<=3Bblob>=3B=2C
 =3B the_geom text
) WITH=
 =3B bloom_filter_fp_chance=3D0.010000 AND
=0A=  =3B caching=3D'KEYS_ONLY' AND
 =3B comment=3D'' AND
 =3B= dclocal_read_repair_chance=3D0.000000 AND
 =3B gc_grace_seconds=3D8= 64000 AND
 =3B read_repair_chance=3D0.100000 AND
 =3B replica= te_on_write=3D'true' AND
=0A=  =3B populate_io_cache_on_flush=3D'false' AND
 =3B compaction=3D= {'class': 'SizeTieredCompactionStrategy'} AND
 =3B compression=3D{'s= stable_compression': 'SnappyCompressor'}=3B


=0A= I run this query "select geom_key=2C the_geom=2C part_geom from geoms l= imit 1=3B" in 700ms.

When I run the same query withou= t part_geom attr (select geom_key=2C the_geom from geoms limit 1=3B)= =2C the query runs in 5 ms.
=0A=
Is there a performance problem with a List<=3Bblob>=3B attribute?

Thanks in advance<= br>=0A=

--
Atenciosamente=2C
S=E1vio S. Teles de Oliveira
voice: += 55 62 9136 6996
http://br.linkedin.com/in/savioteles
=0A=
=0A= =0A= Mestrando em Ci=EAncias da Computa=E7=E3o - UFG
Arquiteto de Software
Laboratory for Ubiquitous and Pervasive Applications (LUP= A) - UFG
=0A=
= --_1e04ba6f-d67e-4834-ab3f-f8c637993dff_--