You are using buffered queries with PHP mysqli in a browser-based web application.

Additional queries on the same session are blocked until the result set is released.

Results are sent from the server to the browser for buffering.

Buffered queries are enabled by default.

Buffered queries should be used on large tables when the result size is unknown.

Results are sent to the calling PHP process for buffering.

Buffered queries must be explicitly enabled using mysqliuseresult.

Large results can have a negative impact on performance.