Re-use prepared PDO Statements

[holtkamp]

Might be a micro-optimization, but it might be an idea to re-use PDO Statements.

Something like:

class PDOAdapter extends AbstractAdapter
{
    private $writeStatement;

    private function getWriteStatement() : PDOStatement {
        return $this->writeStatement ?: $this->writeStatement = $this->pdo->prepare(
            "INSERT INTO {$this->table} (path, contents, size, type, mimetype, timestamp) VALUES(:path, :contents, :size, :type, :mimetype, :timestamp)"
        );
    }

    private function write() {
       $statement = $this->getWriteStatement();

       //do magic
    }
}

In case a lot of writes / reads, etc are involved, this prevents assembling a new PDO Statement over and over 🤓