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 89663DF96 for ; Thu, 6 Sep 2012 14:01:46 +0000 (UTC) Received: (qmail 11641 invoked by uid 500); 6 Sep 2012 14:01:43 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 11620 invoked by uid 500); 6 Sep 2012 14:01:43 -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 11612 invoked by uid 99); 6 Sep 2012 14:01:43 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Sep 2012 14:01:43 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [192.174.58.134] (HELO XEDGEA.nrel.gov) (192.174.58.134) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Sep 2012 14:01:38 +0000 Received: from XHUBB.nrel.gov (10.20.4.59) by XEDGEA.nrel.gov (192.174.58.134) with Microsoft SMTP Server (TLS) id 8.3.245.1; Thu, 6 Sep 2012 08:01:17 -0600 Received: from MAILBOX2.nrel.gov ([fe80::19a0:6c19:6421:12f]) by XHUBB.nrel.gov ([::1]) with mapi; Thu, 6 Sep 2012 08:01:17 -0600 From: "Hiller, Dean" To: "user@cassandra.apache.org" Date: Thu, 6 Sep 2012 08:01:17 -0600 Subject: playOrm S-SQL comparison with CQL Thread-Topic: playOrm S-SQL comparison with CQL Thread-Index: Ac2MOBXHlLEjiGu5RpaQjzoKRRorWw== Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.2.3.120616 acceptlanguage: en-US Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org Someone asked so I wrote the difference here https://github.com/deanhiller/playorm/wiki/Fast-Scalable-Queries playOrm queries are geared for a different problem then CQL is geared for. Summary is basically playOrm uses significantly less resources as it only q= ueries the partitions it is interested in. This is also why playOrm can do= joins very quickly as well. Dean