Re: Non-Buffered mysqld

2001-11-14 Thread Bill Adams
Jeremy Zawodny wrote: > On Wed, Nov 14, 2001 at 12:07:04PM -0800, Bill Adams wrote: > > The most important exception is the mysql_use_result attribute: This > > forces the driver to use mysql_use_result rather than > > mysql_store_result. The former is faster and less memory consuming, > > but te

Re: Non-Buffered mysqld

2001-11-14 Thread Jeremy Zawodny
On Wed, Nov 14, 2001 at 12:07:04PM -0800, Bill Adams wrote: > Man I just cannot stop replying to myself... I've had days like that, too. > > The most important exception is the mysql_use_result attribute: This > forces the driver to use mysql_use_result rather than > mysql_store_result. The form

Re: Non-Buffered mysqld

2001-11-14 Thread Bill Adams
Man I just cannot stop replying to myself... Bill Adams wrote: > Bill Adams wrote: > > > Rick Emery wrote: > > > > > If you use PHP, the answer is:mysql_unbuffered_query() > > > > Well, I get the delay if I query with perl DBI or enter the query directly in > > the mysql client. perl DBI

Re: Non-Buffered mysqld

2001-11-14 Thread Bill Adams
Bill Adams wrote: > Rick Emery wrote: > > > If you use PHP, the answer is:mysql_unbuffered_query() > > Well, I get the delay if I query with perl DBI or enter the query directly in > the mysql client. perl DBI + Informix does not buffer so I know that it is > not that combo. (I guess it cou

Re: Non-Buffered mysqld

2001-11-14 Thread Bill Adams
Rick Emery wrote: > If you use PHP, the answer is:mysql_unbuffered_query() Well, I get the delay if I query with perl DBI or enter the query directly in the mysql client. perl DBI + Informix does not buffer so I know that it is not that combo. (I guess it could be the DBD::mysql.) While t

RE: Non-Buffered mysqld

2001-11-14 Thread Rick Emery
If you use PHP, the answer is:mysql_unbuffered_query() -Original Message- From: Bill Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 11:38 AM To: Mysql List Subject: Non-Buffered mysqld MySQL 4.0 Is there a way to prevent mysql(d) from buffering the output ala '