jeroen Wed May 16 15:46:44 2001 EDT
Modified files:
/phpdoc/en/functions mysql.xml
Log:
Reapplied 1.37 -> 1.40 patches
Index: phpdoc/en/functions/mysql.xml
diff -u phpdoc/en/functions/mysql.xml:1.41 phpdoc/en/functions/mysql.xml:1.42
--- phpdoc/en/functions/mysql.xml:1.41 Wed May 16 08:25:31 2001
+++ phpdoc/en/functions/mysql.xml Wed May 16 15:46:43 2001
@@ -479,7 +479,8 @@
arguments
</para>
<para>
- See also <function>mysql_connect</function>.
+ See also <function>mysql_connect</function> and
+ <function>mysql_query</function>.
</para>
<para>
For downwards
@@ -1764,10 +1765,55 @@
<para>
See also: <function>mysql_affected_rows</function>,
<function>mysql_db_query</function>,
+ <function>mysql_unbuffered_query</function>,
<function>mysql_free_result</function>,
<function>mysql_result</function>,
<function>mysql_select_db</function>, and
<function>mysql_connect</function>.
+ </para>
+ </refsect1>
+ </refentry>
+
+ <refentry id="function.mysql-unbuffered-query">
+ <refnamediv>
+ <refname>mysql_unbuffered_query</refname>
+ <refpurpose>Send an SQL query to MySQL, without fetching and buffering the result
+rows</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>mysql_unbuffered_query</function></funcdef>
+ <paramdef>string <parameter>query</parameter></paramdef>
+ <paramdef>int
+ <parameter><optional>link_identifier</optional></parameter>
+ </paramdef>
+ <paramdef>int
+ <parameter><optional>result_mode</optional></parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>mysql_unbuffered_query</function> sends a SQL query to MySQL,
+ without fetching and buffering the result rows automatically, as
+ <function>mysql_query</function> 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 the complete SQL query has been
+ performed.
+ </para>
+ <note>
+ <para>
+ The benefits of <function>mysql_unbuffered_query</function> come at a
+ cost: You cannot use <function>mysql_num_rows</function> on a result set
+ returned from <function>mysql_unbuffered_query</function>. You also have
+ to fetch all result rows from an unbuffered SQL query, before you can
+ send a new SQL query to MySQL.
+ </para>
+ </note>
+ <para>
+ See also: <function>mysql_query</function>.
</para>
</refsect1>
</refentry>
