phpcassa - Cassandra performance -

phpcassa - Cassandra performance -

i have read these articles how fast cassandra can be, illustration single row read can take 5ms.

so far didn't care much website speeds, site grew bigger pages started require quite few queries, illustration 1 page requires read 5 different tables , around 50 different rows, , have noticed takes 0.7 sec 2.0 secs slow, took closer , found out single query takes 150ms.

the table i'm testing empty size can't issue. have installed apc , did not help.

i using phpcassa , thrift comes along library.

are these speeds normal, maybe php not fast enough? improve situation?

note, understand running many queries much , cassandra optimized writes not reads, in situations can't find way set info in single table/row.

edit have found out optional c extension should improve performance, , indeed does, single row read takes 50ms 100ms that's major improvement, thou still far away 5ms

edit2 sorry not updating question more information, have been busy, , have solved problem, 10 row reads 4 different tables takes 0.073158 s , average read time 0.005575 s it's way more have expected achieve. facing same problem these things suggest do:

install optional c extension, steps can found here install apc make sure right java version installed, causing slowdown after installing these things don't restart apache, restart whole server, didn't @ first , noticed major speed improvement after server restart

this still doesn't explain why column family empty performs worse others. next time face issue, should give how utilize table , kind of query gave bad performances.

just guess: column family contains deleted data? because actual deletion deleted (tombstoned) values takes gcgraceperiod of 10 days default.

so might face issues if perform lot of writes, reads , deletes on lot of columns on same keys.

cassandra phpcassa