Groups

©2013 GooglePrivacy - Terms of Service -

Google Home

My groups

Home

Starred

Click on a group’s staricon to add it to your

favorites

Favorites

Recently viewed

phpcassa

v8-users

pycassa-discuss

Google Tasks API

Scale 7 - Libraries a…

Recent searches

ram requirements (i…

Connection refused…

vagrant networking …

phpcassa ›

phpcassa vs pdo-cassandra (speed related comparison)3 posts by 2 authors

Dragos 11/22/12

We've had some tests today having some inserts using phpcassa and pdo-cassandraand we would like to share some results.Test bench: 6 nodes (EC2, M1.Large), Datastax AMI with Cassandra 1.1.6, all instancedhaving the same rack and same DC. Replication factor = 3. Consistency level:QUORUM. SimpleStrategy. EC2Snitch.Tests were executed from the 7th EC2 machine (same Availability Zone as those six withCassandra installed).

#1 - phpcassa - single thread - 100K inserts (thrift C library compiled and enabled; querysent as thrift, not as CQL!) - 351 seconds#2 - phpcassa - single thread - 10K inserts (thrift C library compiled and enabled; querysent as thrift, not as CQL!) - 34 seconds#3 - pdo-cassandra - single thread - 100K inserts (CQL2) - 131-160 seconds#4 - pdo-cassandra - single thread - 10K inserts (CQL2) - 13-18 seconds#5 - cassandra stress tool (https://github.com/apache/cassandra/tree/trunk/tools/stress) -java - single thread (-t 1) - 10K inserts - 11-26 seconds (we've tested 5 times and eachtime results were different)#6 - cassandra stress tool (https://github.com/apache/cassandra/tree/trunk/tools/stress) -java - single thread (-t 1) - 100K inserts - 110-210 seconds (we've tested 5 times andeach time results were different)#7 - cassandra stress tool (https://github.com/apache/cassandra/tree/trunk/tools/stress) -java - 100 thread (-t 100) - 1M inserts - 110 seconds (not bad!)

Any ideas why phpcassa (compiled C thrift library) is so slow compared withpdo-cassandra (this one has libthrift)? We would like to keep using phpcassa and "thrift"like syntax (at least until CQL3 is stable and has some "history"), but we need to run itfaster.

We will try having some opcode cached (apc) - maybe that will help also. Also we will trysending CQL2 from phpcassa to figure out if that makes any difference.

I'm a bit "affraid" of using pdo-cassandra (READ.me from repository states very clearly itis: "Pretty much very experimental PDO driver for Cassandra CQL"; phpinfo does noteven show what version number I have; does not compile on Ubuntu 12.10 and php5.4.6); phpcassa proved very reliable during last 16 months (except that little-endian,big-endian hit) - great job Tyler Hobbs. I thank you for your efforts!

Dragos 11/22/12

Mohammed Makhlouf Share

+Mohammed Search Images Maps Play YouTube News Gmail Drive Calendar More

phpcassa vs pdo-cassandra (speed related comparison) -... https://groups.google.com/forum/#!topic/phpcassa/6vY_...

1 of 1 08/29/2013 09:16 AM