bject: Re: [PHP] PHP mysql data result set compression
Hi David,
From the comments on unbuffered_query:
However, when using different db connections, it all works ofcource ...
So create a second db connection and when you run the insert use that
instead:
$result2 = mysql_query("insert blah
w/o disk swapping then that would be the fastest way to do
this?
David
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Monday, February 06, 2006 4:50 PM
To: David Yee
Cc: 'php-general@lists.php.net'
Subject: Re: [PHP] PHP mysql data result set compression
Hi Dav
:[EMAIL PROTECTED]
Sent: Monday, February 06, 2006 4:16 PM
To: David Yee
Cc: 'php-general@lists.php.net'
Subject: Re: [PHP] PHP mysql data result set compression
Hi David,
See http://www.php.net/mysql_unbuffered_query
It won't load the whole lot into memory before returning it to
On Mon, 2006-02-06 at 19:39, David Yee wrote:
> I'm still not sure why the MYSQL_CLIENT_COMPRESS didn't seem to have an effect
That causes the data to be transfered from the MySQL server to the
client with compression. The results are still uncompressed on the
client.
Cheers,
Rob.
--
.--
;t seem to have an effect, however.
David
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Monday, February 06, 2006 4:16 PM
To: David Yee
Cc: 'php-general@lists.php.net'
Subject: Re: [PHP] PHP mysql data result set compression
Hi David,
See http://www.php.net/mysql_
Hi David,
See http://www.php.net/mysql_unbuffered_query
It won't load the whole lot into memory before returning it to php.
David Yee wrote:
Hi all- is there a way have a large data result set from MySQL compressed?
E.g. I have a table with over a million rows of data that I want to do a
"sele
On 6 Feb 2006 at 16:03, David Yee wrote:
> Hi all- is there a way have a large data result set from MySQL compressed?
> E.g. I have a table with over a million rows of data that I want to do a
> "select * from " on and then take that result, do some field/data
> manpulation, and then insert row-by
Hi all- is there a way have a large data result set from MySQL compressed?
E.g. I have a table with over a million rows of data that I want to do a
"select * from " on and then take that result, do some field/data
manpulation, and then insert row-by-row to another table. The problem is
the result
8 matches
Mail list logo
