cvs: phpdoc /en/functions mysql.xml

From: Date: Sat, 12 May 2001 06:13:23 +0000
Subject: cvs: phpdoc /en/functions mysql.xml
Groups: php.doc 
Request: Send a blank email to phpdoc+get-969335266@lists.php.net to get a copy of this message
sbergmann Fri May 11 23:13:23 2001 EDT Modified files: /phpdoc/en/functions mysql.xml Log: Added documentation for mysql_unbuffered_query(). Index: phpdoc/en/functions/mysql.xml diff -u phpdoc/en/functions/mysql.xml:1.37 phpdoc/en/functions/mysql.xml:1.38 --- phpdoc/en/functions/mysql.xml:1.37 Thu Mar 8 13:56:37 2001 +++ phpdoc/en/functions/mysql.xml Fri May 11 23:13:23 2001 @@ -1756,6 +1756,50 @@ </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> + <refentry id="function.mysql-result"> <refnamediv> <refname>mysql_result</refname>

« previous php.doc (#969335266) next »