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 4BB45FBC7 for ; Sun, 24 Mar 2013 12:21:52 +0000 (UTC) Received: (qmail 27485 invoked by uid 500); 24 Mar 2013 12:21:50 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 27320 invoked by uid 500); 24 Mar 2013 12:21:49 -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 27258 invoked by uid 99); 24 Mar 2013 12:21:47 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 24 Mar 2013 12:21:47 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of zhang.ihep@gmail.com designates 209.85.216.66 as permitted sender) Received: from [209.85.216.66] (HELO mail-qa0-f66.google.com) (209.85.216.66) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 24 Mar 2013 12:21:40 +0000 Received: by mail-qa0-f66.google.com with SMTP id hg5so246694qab.5 for ; Sun, 24 Mar 2013 05:21:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=vkC5cX/eSRyVZoEkb7gT0osUXeFJCAy5JfkxKSpCrvg=; b=R0F0AAx2w3X8KUlY1hvojYmLNlW8CfuQmVUCABFvQrtW93a9g8/5LhUKLpQFFIw+j/ bhFEelE3f79s97TFnAFbNNGVvFjqoNluAJjVOKwd3Beb5Z/KJ0Zd3R7J3Du/Lz1LqLvj 7/talX+PmRJBRfWo6yNBul8p65zXiaBqrOu1qk4kpoo1GB4HfmS+2d2X3y2SX/0/Kerc hJHGZsJSttKm66M9evd4lGsyUBoYdqlgHN22XkzFQ72uyunTjZXT/tLhaOLpMVPSN2z8 VmiA0poPSgUgSm/bhNMgBFmxuIUGL8EAFchgqH4O5VZnzevS1Iysf51ma65OvAmcgBdi EqLw== MIME-Version: 1.0 X-Received: by 10.224.10.144 with SMTP id p16mr98569qap.47.1364127680015; Sun, 24 Mar 2013 05:21:20 -0700 (PDT) Received: by 10.49.18.5 with HTTP; Sun, 24 Mar 2013 05:21:19 -0700 (PDT) In-Reply-To: References: Date: Sun, 24 Mar 2013 20:21:19 +0800 Message-ID: Subject: Re: cassandra performance From: =?GB2312?B?1cW41Q==?= To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=14dae9399b03cbb59004d8aab948 X-Virus-Checked: Checked by ClamAV on apache.org --14dae9399b03cbb59004d8aab948 Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: quoted-printable For example,each row represent a job record,it has fields like "user","site","CPUTime","datasize","JobType"... The fields in CF is fixed,just like a table.The query like this "select CPUTime,User,site from CF(or tablename) where user=3Dxxx and Jobtype=3Dxxx" Best regards 2013/3/24 cem > Hi, > > Could you provide some other details about your schema design and queries= ? > It is very hard to tell anything. > > Regards, > Cem > > > On Sun, Mar 24, 2013 at 12:40 PM, dong.yajun wrote: > >> Hello, >> >> I'd suggest you to take look at the difference between Nosql and RDMS. >> >> Best, >> >> On Sun, Mar 24, 2013 at 5:15 PM, =D5=C5=B8=D5 wro= te: >> >>> Hello, >>> I am new to Cassandra.I do some test on a single machine. I install >>> Cassandra with a binary tarball distribution. >>> I create a CF to store the data that get from MySQL. The CF has the sam= e >>> fields as the table in MySQL. So it looks like a table. >>> I do the same select from the CF in Cassandra and the table in MySQL,an= d >>> I find the processing time of MySQL is better than Cassandra. >>> So,I wander what are the advantages of Cassandra compare MySQL and how >>> to improve the performance of Cassandra. >>> Is this the right way to use Cassandra. >>> >>> >> >> >> -- >> *Ric Dong* >> >> > --14dae9399b03cbb59004d8aab948 Content-Type: text/html; charset=GB2312 Content-Transfer-Encoding: quoted-printable
For example,each row represent a job record,it has fields = like "user","site","CPUTime","datasize&q= uot;,"JobType"...
The fields in CF is fixed,just like a= table.The query like this "select CPUTime,User,site from CF(or tablen= ame) where user=3Dxxx and Jobtype=3Dxxx"

Best regards


2013/3/24 cem = <cayiroglu@gmai= l.com>
Hi,

Could you provide som= e other details about your schema design and queries? It is very hard to te= ll anything.

Regards,
Cem


On Sun, Mar 24, 2013 at 12:40 PM, dong.yajun <do= ngtalk@gmail.com> wrote:
Hello,

 I'd suggest you to = take look at the difference between Nosql and RDMS.

Best,

On Sun, Mar 24, 2013 at 5:15 PM, =D5=C5= =B8=D5 <zhang.ihep@gmail.com> wrote:
Hello,
I am new to Cassandra.I do some test on a singl= e machine. I install Cassandra with a binary tarball distribution.
I create a CF to store the data that get from MySQL. The CF has the same = fields as the table in MySQL. So it looks like a table. 
I do the same select from the CF in Cassandra and the table in MySQL,a= nd I find the processing time of MySQL is better than Cassandra.
= So,I wander what are the advantages of Cassandra compare MySQL and how to i= mprove the performance of Cassandra.
Is this the right way to use Cassandra.




--
Ric Dong


--14dae9399b03cbb59004d8aab948--