Multiget query to cassandra with phpcassa

Question

I am firing the multiget query with 330 keys and 750 columns per row.

Its dying somewhere in the phpcassa code.The worst thing is, its not throwing any exception.

Script is getting terminated abruptly.Is there any setting I should do ?

Its working fine if I fetch few columns out of these 750 columns

Following is my API call.

multiget($dataCFKeys,$columns = $superColumns, $column_start = "",$column_finish = "", $column_reversed = False,$column_count = $columnCount,$super_column = null,$read_consistency_level = 1,$buffer_size = 100);

Am I missing something.OR is there any configuration that can help me get this work?

Thanks in advance Manish

Answer 1

To answer the question as posed: you're probably hitting the PHP max_execution_time -- PHP configuration: max_execution_time and max_input_time

More generally though I would say that this is not a good way to model data in Cassandra. If you need to crunch through a lot of data, use Hadoop (http://wiki.apache.org/cassandra/HadoopSupport); otherwise, you should model things so you can get the data you want from a single row or from an index.