Re: cassandra performance looking great...

2012-09-07 Thread Hiller, Dean
Now that would be cool. Right now though, to many other features need to be added like a GUI on top of the ad-hoc query tool is the next top priority so one can do any S-SQL statement and ad-hoc query the heck out of a noSQL store. We may even be able to optimize our queries to be even faster

Re: cassandra performance looking great...

2012-09-07 Thread Edward Capriolo
Try to get Cassandra running the TPH-C benchmarks and beat oracle :) On Fri, Sep 7, 2012 at 10:01 AM, Hiller, Dean wrote: > So we wrote 1,000,000 rows into cassandra and ran a simple S-SQL(Scalable > SQL) query of > > > PARTITIONS n(:partition) SELECT n FROM TABLE as n WHERE n.numShares >= :low

cassandra performance looking great...

2012-09-07 Thread Hiller, Dean
So we wrote 1,000,000 rows into cassandra and ran a simple S-SQL(Scalable SQL) query of PARTITIONS n(:partition) SELECT n FROM TABLE as n WHERE n.numShares >= :low and n.pricePerShare >= :price It ran in 60ms So basically playOrm is going to support millions of rows per partition. This is g