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 D40487D27 for ; Thu, 21 Jul 2011 00:13:44 +0000 (UTC) Received: (qmail 51354 invoked by uid 500); 21 Jul 2011 00:13:42 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 51329 invoked by uid 500); 21 Jul 2011 00:13:41 -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 51320 invoked by uid 99); 21 Jul 2011 00:13:41 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Jul 2011 00:13:41 +0000 X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests=MIME_QP_LONG_LINE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a53.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Jul 2011 00:13:34 +0000 Received: from homiemail-a53.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a53.g.dreamhost.com (Postfix) with ESMTP id 5726B13806A for ; Wed, 20 Jul 2011 17:13:08 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=subject :references:from:content-type:in-reply-to:message-id:date:to :content-transfer-encoding:mime-version; q=dns; s= thelastpickle.com; b=th6uaks1MYT2PJO5DCqFyCRuIdYJrEZ8RAEIAgQiVYx byTaaSoovpAkhQ/0C9p5+w3NtknHuOj+9p3R3IhBuJd0yuVPL602QTeVduDGjHd5 u5AA9nc9veXZrNK+jWyyfvT6+gcNeTO7y3floZphI0ojqGVFsEk6HKDBtb2dzuks = DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h= subject:references:from:content-type:in-reply-to:message-id:date :to:content-transfer-encoding:mime-version; s=thelastpickle.com; bh=ULSz/81GNDLWoFMR4fH52HzB+vk=; b=ZVPW0RZGK4ekKTti+cLaundMRBbd 092MxsmuqFaWHTKRl5YFQlk4j9rjuI+LgGv5eoOxOTl12axJAjGebePgvk0rAWtS stivDZJjJ6dUk9RugfgqyMrWfSzDJ5FDx1orYBIxKiX5Y9Vw4OOtuPTUF+7mya/N PKnb9xvLEmPKh2U= Received: from [10.0.1.151] (121-73-157-230.cable.telstraclear.net [121.73.157.230]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a53.g.dreamhost.com (Postfix) with ESMTPSA id 2A08B138069 for ; Wed, 20 Jul 2011 17:13:08 -0700 (PDT) Subject: Re: PHPCassa get number of rows References: From: Aaron Morton Content-Type: text/plain; charset=us-ascii X-Mailer: iPad Mail (8K2) In-Reply-To: Message-Id: Date: Thu, 21 Jul 2011 12:14:21 +1200 To: "user@cassandra.apache.org" Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (iPad Mail 8K2) X-Virus-Checked: Checked by ClamAV on apache.org Cassandra does not provide a way to count the number of rows, the best you c= an do is a series of range calls and count them on the client side=20 http://thobbs.github.com/phpcassa/tutorial.html If this is something you need in your app consider creating a custom seconda= ry index to store the row keys and counting the columns. NOTE: counting colu= mns just reads aol the columns, for a big row it can result in an OOM. Cheers ----------------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 20/07/2011, at 8:29 AM, Jean-Nicolas Boulay Desjardins wrote: > Hi, >=20 > How can I get the number of rows with PHPCassa? >=20 > Thanks in advance.