From cassandra-user-return-2449-apmail-incubator-cassandra-user-archive=incubator.apache.org@incubator.apache.org Wed Feb 03 10:20:23 2010 Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 52293 invoked from network); 3 Feb 2010 10:20:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 3 Feb 2010 10:20:23 -0000 Received: (qmail 41937 invoked by uid 500); 3 Feb 2010 10:20:23 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 41899 invoked by uid 500); 3 Feb 2010 10:20:23 -0000 Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cassandra-user@incubator.apache.org Delivered-To: mailing list cassandra-user@incubator.apache.org Received: (qmail 41890 invoked by uid 99); 3 Feb 2010 10:20:23 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Feb 2010 10:20:23 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of enviouser@gmail.com designates 209.85.223.181 as permitted sender) Received: from [209.85.223.181] (HELO mail-iw0-f181.google.com) (209.85.223.181) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Feb 2010 10:20:16 +0000 Received: by iwn11 with SMTP id 11so1298144iwn.16 for ; Wed, 03 Feb 2010 02:19:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=gJ0J2iISwpLkUwUK0D9ac/zsB0G9ywZ5wtsUtOAlpOA=; b=QkGynA2S3tg9HyDUL1JFpQ8Ufv9SnxoTWD4OgR4cX4PpFh5UoAX9eVK7gp082tcEYY c4GFxW2bLPc4YfG6tfsDoZqtEpAz2wn09RrfCcFeDUmxx3yyP2Ydq8CQEeJkr3aHUqhf BH8H11ASj+oMeVetDU7jL7akQJLyFoAJAX7I8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=D6E2xQPNtMhcmhThf5fEigLhC6xEIu1/Bm9tNfnVmq2kiEciNN+LczjNfhQK7OHLfi OFLdL/vLUDfEp/vFxlWYJKFYwmvqpi1zwZJ0LZqVHQajEQ1YrVKWzFUnhLIcqp0t2Ik2 WeAjD7zGBTEHCJ7YYK68zjC5PN81dbu7MLyj8= MIME-Version: 1.0 Received: by 10.231.147.203 with SMTP id m11mr240166ibv.68.1265192394904; Wed, 03 Feb 2010 02:19:54 -0800 (PST) In-Reply-To: References: Date: Wed, 3 Feb 2010 15:49:54 +0530 Message-ID: Subject: Re: get_slice() slow if more number of columns present in a SCF. From: envio user To: cassandra-user@incubator.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Hi Brandon, > Can you try with a simple CF? Here are the test results: /home/sun>python stress.py -n 100000 -t 100 -c 600 -r -o insert -i 10 ........ 83779,297,0.334478345002,290 86736,295,0.335617337551,300 89621,288,0.337104303915,310 92578,295,0.343658989251,320 95567,298,0.331744175047,330 98515,294,0.291284884979,340 100000,148,0.166682253301,350 /home/sun>python stress.py -n 100000 -t 100 -c 25 -r -o read -i 10 WARNING: multiprocessing not present, threading will be used. Benchmark may not be accurate! total,interval_op_rate,avg_latency,elapsed_time 19828,1982,0.0514599678015,10 40797,2096,0.0473390288764,20 59350,1855,0.0532040532783,30 76317,1696,0.0598703045355,40 100000,2368,0.0332285839526,50 After this I tried with 1 million keys: /home/sun>python stress.py -n 1000000 -t 100 -c 25 -r -o read -i 10 WARNING: multiprocessing not present, threading will be used. Benchmark may not be accurate! total,interval_op_rate,avg_latency,elapsed_time ....................... ....................... 87916,76,1.30730833113,1240 88665,74,1.33158908508,1250 89405,74,1.35333179654,1260 90086,68,1.45503252228,1270 90745,65,1.51978417774,1280 91476,73,1.38719448671,1290 92226,75,1.3288515962,1300 92976,75,1.33220300897,1310 93770,79,1.26187492288,1320 94557,78,1.26394684554,1330 thanks, -Aita