Search Results

1. www.php.net › manual › enPHP: mysql_unbuffered_query - Manual

   www.php.net › manual › en

   mysql_unbuffered_query () sends the SQL query query to MySQL without automatically fetching and buffering the result rows as mysql_query () does. This saves a considerable amount of memory with SQL queries that produce large result sets, and you can start working on the result set immediately after the first row has been retrieved as you don't have to wait until the complete SQL query has been ...

2. stackoverflow.com › questions › 17324239php - Difference between buffered and unbuffered queries ...

   stackoverflow.com › questions › 17324239

   I was always under the impression the difference, in simple terms, between PHP/MySQL buffered and unbuffered queries is that buffered (the default) loads all the data into your results set variable...

   • See: http://php.net/manual/en/mysqlinfo.concepts.buffering.php. Unbuffered MySQL queries execute the query and then return a resource while the da...
   • When you execute an SQL query from PHP, the MySQL server will reply with a status message. This tells PHP (more accurately the client library, e.g....

3. www.php-editors.com › php_manual › functionPHP Editor Review - Php Manual Function mysql-unbuffered-query

   www.php-editors.com › php_manual › function

   mysql_unbuffered_query () sends a SQL query query to MySQL, without fetching and buffering the result rows automatically, as mysql_query () does. On the one hand, this saves a considerable amount of memory with SQL queries that produce large result sets. On the other hand, you can start working on the result set immediately after the first row has been retrieved: you don't have to wait until ...

4. www.creationdev.net › docs › phpfonction-mysql-unbuffered-query.php - creationdev.net

   www.creationdev.net › docs › php

   mysql_unbuffered_query () envoie la requête SQL query à MySQL sans automatiquement récupérer et mettre en mémoire les lignes du résultat, comme pourrait le faire la fonction mysql_query (). Ce comportement permet d'épargner une grande quantité de mémoire lorsque les requêtes SQL produisent un gros jeu de résultats, et vous pouvez commencer à travailler sur le jeu de résultats ...

5. durak.org › functionSend an SQL query to MySQL without fetching and buffering the ...

   durak.org › function

   Sep 9, 2025 · The benefits of mysql_unbuffered_query () come at a cost: you cannot use mysql_num_rows () and mysql_data_seek () on a result set returned from mysql_unbuffered_query (), until all rows are fetched. You also have to fetch all result rows from an unbuffered SQL query before you can send a new SQL query to MySQL, using the same link_identifier.

6. www.php.net › manual › enPHP: Buffered and Unbuffered queries - Manual

   www.php.net › manual › en

   Buffered and Unbuffered queries ¶ Queries are using the buffered mode by default. This means that query results are immediately transferred from the MySQL Server to PHP and then are kept in the memory of the PHP process. This allows additional operations like counting the number of rows, and moving (seeking) the current result pointer.

7. People also ask

   How do unbuffered MySQL queries work?

   • Unbuffered MySQL queries execute the query and then wait for the data from the MySQL server to be fetched. This uses less memory on the PHP-side, but can increase the load on the server. Unless the full result set was fetched from the server no further queries can be sent over the same connection.

   Buffered and Unbuffered queries - PHP

   www.php.net/manual/en/mysqlinfo.concepts.buffering.php

   See all results for this question

   What is the difference between buffered & unbuffered queries in PHP/MySQL?

   • I was always under the impression the difference, in simple terms, between PHP/MySQL buffered and unbuffered queries is that buffered (the default) loads all the data into your results set variable and then you can start using them whereas unbuffered loads a row at a time.

   php - Difference between buffered and unbuffered queries - Stack Over…

   stackoverflow.com/questions/17324239/difference-between-buffered-and-unbuffered-queries

   See all results for this question

   What is MySQL_unbuffered_query?

   • mysql_unbuffered_query — Send an SQL query to MySQL without fetching and buffering the result rows This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide. Alternatives to this function include:

   PHP: mysql_unbuffered_query - Manual

   www.php.net/manual/en/function.mysql-unbuffered-query.php

   See all results for this question

   What is a buffered MySQL Query?

   • Buffered queries have the following features: Unbuffered MySQL queries have the following features: The default mode is usually buffered. Only mysqli prepared statements return unbuffered result sets by default. You can ask mysqlnd to buffer them by calling $stmt->store_result() or by fetching the mysqli_result object using $stmt->get_result().

   php - Difference between buffered and unbuffered queries - Stack Over…

   stackoverflow.com/questions/17324239/difference-between-buffered-and-unbuffered-queries

   See all results for this question

8. www.hscripts.com › mysql-unbuffered-queryPHP Mysql Tutorials, Function, mysql_unbuffered_query ()

   www.hscripts.com › mysql-unbuffered-query

   Returns the query handle for SELECT queries, TRUE/FALSE for other queries, or FALSE on failure. mysql_unbuffered_query () sends a SQL query to MySQL, without fetching and buffering the result rows automatically, as mysql_query () does. This saves a considerable amount of memory with SQL queries that produce large result sets.