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 779AD102AE for ; Tue, 3 Sep 2013 21:44:20 +0000 (UTC) Received: (qmail 66534 invoked by uid 500); 3 Sep 2013 21:44:17 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 66505 invoked by uid 500); 3 Sep 2013 21:44:17 -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 66485 invoked by uid 99); 3 Sep 2013 21:44:13 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Sep 2013 21:44:13 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW X-Spam-Check-By: apache.org Received-SPF: error (nike.apache.org: local policy) Received: from [74.125.82.179] (HELO mail-we0-f179.google.com) (74.125.82.179) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Sep 2013 21:44:08 +0000 Received: by mail-we0-f179.google.com with SMTP id t58so5418320wes.10 for ; Tue, 03 Sep 2013 14:43:26 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=dBiw4ULXL08bFbV2YyOccph2smEPXJodISj0z1FtSIg=; b=kgwQq/T0c1Fmz8AfB5wwx9QMX8Ro+w4PyaGmaZeEf0JwrO5cjDNztVorVZmQ3eOtEb 9G7RN1BVRjycN2jgCauwxCl1b3fHsGzXGkaKWBUwnUWPtvo+xW4/Gc+NNSiOEjIMvIZv ev/W+pN8o21ufhNUSO+0IdifAKcADpVihnHH3Xh+wXHU7aBt5yZXEdfLrO7VBHasNqRR zIneIhHP/PFFhrkKxr00lJxAVrQhTU2otk3FRax4rHeHfSyqnNcvwtPu1+x2v5vTvm7z /JDBDndAxBhjpbWM//m/DNsz47UmTUkMSw0sM/B/AC5SNLiYI7uDsOHKK1Tq0NU3TeBr 73ag== X-Gm-Message-State: ALoCoQkf67aZ1NN6m0gwIABOWN5CaJ5809W/K3CxT6FRVEP7E9rf0oCU86ZoN1gKUd/eu1nlEFf4 MIME-Version: 1.0 X-Received: by 10.194.123.227 with SMTP id md3mr29422955wjb.17.1378244606115; Tue, 03 Sep 2013 14:43:26 -0700 (PDT) Received: by 10.194.46.166 with HTTP; Tue, 3 Sep 2013 14:43:26 -0700 (PDT) X-Originating-IP: [200.137.197.228] In-Reply-To: References:

Date: Tue, 3 Sep 2013 18:43:26 -0300 Message-ID: Subject: Re: List retrieve performance From: =?ISO-8859-1?Q?S=E1vio_Teles?= To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=089e01229a5829518104e581949e X-Virus-Checked: Checked by ClamAV on apache.org --089e01229a5829518104e581949e Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable The list is "null". 2013/9/3 Baskar Duraikannu > I don't know of any. I would check the size of LIST. If it is taking long= , > it could be just that disk read is taking long. > > ------------------------------ > Date: Sat, 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, > part_geom list, > the_geom text > ) WITH > bloom_filter_fp_chance=3D0.010000 AND > 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 > populate_io_cache_on_flush=3D'false' AND > compaction=3D{'class': 'SizeTieredCompactionStrategy'} AND > compression=3D{'sstable_compression': 'SnappyCompressor'}; > > > I run this query "*select geom_key, the_geom, part_geom from geoms limit > 1;*" in 700ms. > > When I run the same query without part_geom attr (*select geom_key, > the_geom from geoms limit 1;)*, the query runs in 5 ms. > > *Is there a performance problem with a List attribute? > > * > *Thanks in advance > * > > -- > Atenciosamente, > S=E1vio S. Teles de Oliveira > voice: +55 62 9136 6996 > http://br.linkedin.com/in/savioteles > Mestrando em Ci=EAncias da Computa=E7=E3o - UFG > Arquiteto de Software > Laboratory for Ubiquitous and Pervasive Applications (LUPA) - UFG > --=20 Atenciosamente, S=E1vio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ci=EAncias da Computa=E7=E3o - UFG Arquiteto de Software Laboratory for Ubiquitous and Pervasive Applications (LUPA) - UFG --089e01229a5829518104e581949e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

The list is "null".

2013/9/3 Baskar Duraikannu <baskar.duraikannu@outlook.com>

I don't know of any. I would check the size of LI= ST. If it is taking long, it could be just that disk read is taking long. = =A0

Date: Sat, 31 Aug 2013 16:35:22 -0300
Subject: List&= lt;blob> retrieve performance
From: savi= o.teles@lupa.inf.ufg.br
To: user@cassandra.apache.org
=

I have a column family with this conf:

CR= EATE TABLE geoms (
=A0 geom_key text PRIMARY KEY,
=A0 part_geom list&= lt;blob>,
=A0 the_geom text
) WITH
=A0 bloom_filter_fp_chance= =3D0.010000 AND
=A0 caching=3D'KEYS_ONLY' AND
=A0 comment=3D'' AND
= =A0 dclocal_read_repair_chance=3D0.000000 AND
=A0 gc_grace_seconds=3D864= 000 AND
=A0 read_repair_chance=3D0.100000 AND
=A0 replicate_on_write= =3D'true' AND
=A0 populate_io_cache_on_flush=3D'false' AND
=A0 compaction=3D{&= #39;class': 'SizeTieredCompactionStrategy'} AND
=A0 compress= ion=3D{'sstable_compression': 'SnappyCompressor'};

<= br>
I run this query "select geom_key, the_geom, part_geom from geoms = limit 1;" in 700ms.

When I run the same query wi= thout part_geom attr (select geom_key, the_geom from geoms limit 1;)= , the query runs in 5 ms.

Is there a performance problem with a List<blob> attribute?

Thanks in advance

--
Atenciosamente,
S=E1vio S. Teles de Oliveira
voice: +55 62 9136 6996
http://b= r.linkedin.com/in/savioteles

Mestrando em Ci=EAncias da Computa=E7=E3o - UFG
Arquiteto de Software
Laboratory for Ubiquitous and Pervasive Applications (LUP= A) - UFG

--
Atenciosamente,
S=E1vio S. Teles de Oliveira

voice: +55 62 9136= 6996
http://br.linkedin.com/in/savioteles

Mestrando em Ci=EAncias da Computa=E7=E3o - UFG
Arquiteto de Software

Laboratory for Ubiquitous and Pervasive Applications (LUP= A) - UFG

--089e01229a5829518104e581949e--