1.2.449. Fetch One Row Format

When reading results with ext/Sqlite3, it is recommended to explicitly request SQLITE3_NUM or SQLITE3_ASSOC, while avoiding the default value and SQLITE3_BOTH.

This is a micro-optimisation. The difference may be visible with 200k rows fetches, and measurable with 10k.

<?php

$res = $database->query($query);

// Fastest version, but less readable
$row = $res->fetchArray(\SQLITE3_NUM);
// Almost the fastest version, and more readable
$row = $res->fetchArray(\SQLITE3_ASSOC);

// Default version. Quite slow
$row = $res->fetchArray();

// Worse case
$row = $res->fetchArray(\SQLITE3_BOTH);

?>

1.2.449.1. Suggestions

• Specify the result format when reading rows from a Sqlite3 database

1.2.449.2. Specs

Short name	Performances/FetchOneRowFormat
Rulesets	All, Changed Behavior, Performances
Exakat since	0.9.6
PHP Version	All
Severity	Minor
Time To Fix	Instant (5 mins)
Precision	High
Features	csv
Available in	Entreprise Edition, Exakat Cloud