Re: [PHP-DEV] Re: mysql and unbuffered queries

2001-05-07 Thread Wez Furlong
On 2001-05-07 12:22:13, "Zeev Suraski" <[EMAIL PROTECTED]> wrote: > It's going to be a bit complex to explain why I didn't want this patch, > but I'll give it a try :) It's OK, I understand. I just wish that you had said this before I comitted the patch ;-) > First off, my personal preference w

Re: [PHP-DEV] Re: mysql and unbuffered queries

2001-05-07 Thread Cynic
ah, ok, I posted before reading this... anyway, I'd suggest mysql_query_unbuffered instead of mysql_unbuffered_query. At 13:22 7.5. 2001, Zeev Suraski wrote the following: -- >At 12:23 7/5/2001, Wez Furlong wrote: >>On 2001-05-07 00:26

Re: [PHP-DEV] Re: mysql and unbuffered queries

2001-05-07 Thread Cynic
what about st. like #define MYSQL_QUERY_BUFFERED 0 #define MYSQL_QUERY_UNBUFFERED 1 mysql_query( string query [, int link_identifier [, int mode ]]) mysql_db_query( string database , string query [, int link_identifier [, int mode ]]) with mode defaulting to MYSQL_BUFFERED? so much for the issu

Re: [PHP-DEV] Re: mysql and unbuffered queries

2001-05-07 Thread Zeev Suraski
At 12:23 7/5/2001, Wez Furlong wrote: >On 2001-05-07 00:26:02, "Zeev Suraski" <[EMAIL PROTECTED]> wrote: > > At 02:16 7/5/2001, Wez Furlong wrote: > > >Should I create a patch that enables the parameter? > > Probably... Are you sure you can't use mysql_unbuffered_query(), > > though? If you're r

Re: [PHP-DEV] Re: mysql and unbuffered queries

2001-05-07 Thread Wez Furlong
On 2001-05-07 11:54:45, "Zeev Suraski" <[EMAIL PROTECTED]> wrote: > At 13:51 7/5/2001, Wez Furlong wrote: > >The disadvantage is that you have to retrieve all the rows before you > >can issue further SQL on that connection. > > Zeev, Does the extension take care of this case, or > >does it just re

Re: [PHP-DEV] Re: mysql and unbuffered queries

2001-05-07 Thread Zeev Suraski
At 13:51 7/5/2001, Wez Furlong wrote: >On 2001-05-07 11:07:14, "Jani Taskinen" <[EMAIL PROTECTED]> wrote: > > Second question is: What is the use of mysql_query() function anymore > > then? Why not just exchange mysql_query() with >mysql_unbuffered_query()? > > You didn't say anything about any di

Re: [PHP-DEV] Re: mysql and unbuffered queries

2001-05-07 Thread Zeev Suraski
At 13:07 7/5/2001, Jani Taskinen wrote: >Second question is: What is the use of mysql_query() function anymore >then? Why not just exchange mysql_query() with mysql_unbuffered_query() ? > >You didn't say anything about any disadvantages on using it. :) Well there are some advantages: - In small

Re: [PHP-DEV] Re: mysql and unbuffered queries

2001-05-07 Thread Wez Furlong
On 2001-05-07 11:07:14, "Jani Taskinen" <[EMAIL PROTECTED]> wrote: > Second question is: What is the use of mysql_query() function anymore > then? Why not just exchange mysql_query() with mysql_unbuffered_query()? > You didn't say anything about any disadvantages on using it. :) The disadvantage

[PHP-DEV] Re: mysql and unbuffered queries

2001-05-07 Thread Wez Furlong
On 2001-05-07 00:26:02, "Zeev Suraski" <[EMAIL PROTECTED]> wrote: > At 02:16 7/5/2001, Wez Furlong wrote: > >Should I create a patch that enables the parameter? > Probably... Are you sure you can't use mysql_unbuffered_query(), > though? If you're really used to supplying the database argument,

Re: [PHP-DEV] Re: mysql and unbuffered queries

2001-05-07 Thread Jani Taskinen
Second question is: What is the use of mysql_query() function anymore then? Why not just exchange mysql_query() with mysql_unbuffered_query() ? You didn't say anything about any disadvantages on using it. :) --Jani On Mon, 7 May 2001, Zeev Suraski wrote: >It can be used pretty much anywhere m

Re: [PHP-DEV] Re: mysql and unbuffered queries

2001-05-07 Thread Sascha Schumann
> Hmm..this seems to be an undocumented function. What is the use of it? > Benefits over using mysql_query() for example? Where/when it _can't_ be used? Apparently, the mysql client library loads the complete result set into the process space of the client. For example, bugstats.php

Re: [PHP-DEV] Re: mysql and unbuffered queries

2001-05-07 Thread Zeev Suraski
It can be used pretty much anywhere mysql_query() can be used. It's new, that's why it's not documented :) The benefits of it: - At no point does the client (PHP) have to hold the entire result set in memory. With big query results, it can save a lot of RAM. - Response time is generally better,

Re: [PHP-DEV] Re: mysql and unbuffered queries

2001-05-07 Thread Jani Taskinen
On Mon, 7 May 2001, Zeev Suraski wrote: >At 02:16 7/5/2001, Wez Furlong wrote: >>I've seen "mysql_unbuffered_query" mentioned a couple of times lately and I >>thought that it would be useful for my current project. >>However, I need the functionality of mysql_db_query, but working in >>unbuffered

[PHP-DEV] Re: mysql and unbuffered queries

2001-05-06 Thread Zeev Suraski
At 02:16 7/5/2001, Wez Furlong wrote: >I've seen "mysql_unbuffered_query" mentioned a couple of times lately and I >thought that it would be useful for my current project. >However, I need the functionality of mysql_db_query, but working in >unbuffered mode. >I was about to produce a patch and not