Search code examples
cassandraphpcassa

Multiget query to cassandra with phpcassa


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


Solution

  • 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.