Hi,

I querying my database using a script in PHP and returning the result as a JSON (so that it can be retrieved in Javascript).

However I notice that querying the database (sending the query to the database) takes about half the time if takes PHP to retrieve the rows (row by row using monetdb_fetch_object).

In the documentation I see that the MAPI interface has a fetch_all_rows function, however I can't find this function in the PHP library. In the Python example I see that you are also using a cursor.fetchall() procedure.

What is the best way to approach this problem > querying the database and returning all rows as a JSON object

Is PHP the way to go (it is the easiest for me, since I know that), if it is, what is the best way or should I consider another language like Python or maybe Java to implement this function?

Below I list the PHP code I see that send the query ($q_statement) to the database and formulating the JSON:

// Measure time

$time_end = microtime(true);

$execution_time = ($time_end - $time_start); //dividing with 60 will give the execution time in minutes other wise seconds

error_log($execution_time.'sec - Formulate query');

$time_start = microtime(true);

$db = monetdb_connect($lang = "sql", $host = "127.0.0.1", $port = "50000" , $username = "monetdb", $password = "monetdb", $database = "social" ) or die(monetdb_last_error());

$res = monetdb_query($db, monetdb_escape_string($q_statement));

// Measure time

$time_end = microtime(true);

$execution_time = ($time_end - $time_start); //dividing with 60 will give the execution time in minutes other wise seconds

error_log($execution_time.'sec - Query database');

$time_start = microtime(true);

/* Iterate over the result set returning rows as objects */

while ( $row = monetdb_fetch_object($res) )

{

$rows[] = $row;

}

echo json_encode($rows);

// Measure time

$time_end = microtime(true);

$execution_time = ($time_end - $time_start); //dividing with 60 will give the execution time in minutes other wise seconds

$total_execution_time = ($time_end - $initial_start);

error_log($execution_time.'sec - Return records');

error_log($total_execution_time.'sec - Total time');

$time_start = microtime(true);

thanks in advance,

Richard