I have been reading into the mysqli library a bit more and came across the note within mysqli stmt store_result()
You must call mysqli_stmt_store_result() for every query that successfully produces a result set (SELECT, SHOW, DESCRIBE, EXPLAIN), and only if you want to buffer the complete result set by the client, so that the subsequent mysqli_stmt_fetch() call returns buffered data.
Does this mean that you should use:
if (!$stmt->execute())
{
//throw exception
}
$stmt->store_result();
while ($stmt->fetch())
{
//do stuff
}
$stmt->free_result();
$stmt->close();
Rather than:
if (!$stmt->execute())
{
//throw exception
}
while ($stmt->fetch())
{
//do stuff
}
$stmt->close();
Does it have a large impact on performance?
