How large is the mysql_query() buffer?

[howa]

For example,

$query = "SELECT ...'";
$res = mysql_query($qu ery);
while($row = mysql_fetch_ass oc($res)) {
// Do sth
}
If the query return say over 1M row, is it limited by the MySQL server
or PHP ?

[Jerry Stuckle]

howa wrote:

For example,

$query = "SELECT ...'";
$res = mysql_query($qu ery);
while($row = mysql_fetch_ass oc($res)) {
// Do sth
}
If the query return say over 1M row, is it limited by the MySQL server
or PHP ?

There is no hard limit in either. Rather, system resources would
probably be your limiting factor.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[howa]

On 1$B7n(B4$BF| (B, $B>e8a(B2$B; ~(B04$BJ,(B, Jerry Stuckle <jstuck...@attg lobal.netwrote:

howa wrote:

For example,

$query = "SELECT ...'";
$res = mysql_query($qu ery);
while($row = mysql_fetch_ass oc($res)) {
// Do sth
}

If the query return say over 1M row, is it limited by the MySQL server
or PHP ?

There is no hard limit in either. Rather, system resources would
probably be your limiting factor.

--

For example, will mysql store all the 1M rows in a buffer, or it will
be fetched sequentially?

[Jerry Stuckle]

howa wrote:

On 1$B7n(B4$BF| (B, $B>e8a(B2$B; ~(B04$BJ,(B, Jerry Stuckle <jstuck...@attg lobal.netwrote:

>howa wrote:

>>For example,
$query = "SELECT ...'";
$res = mysql_query($qu ery);
while($row = mysql_fetch_ass oc($res)) {
// Do sth
}
If the query return say over 1M row, is it limited by the MySQL server
or PHP ?

There is no hard limit in either. Rather, system resources would
probably be your limiting factor.

--

For example, will mysql store all the 1M rows in a buffer, or it will
be fetched sequentially?

For MySQL specific information, try comp.databases. mysql.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[The Natural Philosopher]

Jerry Stuckle wrote:

howa wrote:

>For example,

$query = "SELECT ...'";
$res = mysql_query($qu ery);
while($row = mysql_fetch_ass oc($res)) {
// Do sth
}
If the query return say over 1M row, is it limited by the MySQL server
or PHP ?

There is no hard limit in either. Rather, system resources would
probably be your limiting factor.

Its set soemwhere in PHP.INI..there is a memory limit to what PHP will
use. 16Mbyte default IIRC. Mines at 64Mbyte and I managed to pull a
25Mbyte BLOB in and out of the database.

[The Natural Philosopher]

howa wrote:

On 1$B7n(B4$BF| (B, $B>e8a(B2$B; ~(B04$BJ,(B, Jerry Stuckle <jstuck...@attg lobal.netwrote:

>howa wrote:

>>For example,
$query = "SELECT ...'";
$res = mysql_query($qu ery);
while($row = mysql_fetch_ass oc($res)) {
// Do sth
}
If the query return say over 1M row, is it limited by the MySQL server
or PHP ?

There is no hard limit in either. Rather, system resources would
probably be your limiting factor.

--

For example, will mysql store all the 1M rows in a buffer, or it will
be fetched sequentially?

Buffered.

[Rik Wasmus]

On Fri, 04 Jan 2008 08:52:28 +0100, The Natural Philosopher <[e-mail]:

howa wrote:

>On 1$B7n(B4$BF| (B, $B>e8a(B2$B; ~(B04$BJ,(B, Jerry Stuckle
<jstuck...@att global.netwrote :

>>howa wrote:
For example,
$query = "SELECT ...'";
$res = mysql_query($qu ery);
while($row = mysql_fetch_ass oc($res)) {
// Do sth
}
If the query return say over 1M row, is it limited by the MySQL server
or PHP ?
There is no hard limit in either. Rather, system resources would
probably be your limiting factor.

--

For example, will mysql store all the 1M rows in a buffer, or it will
be fetched sequentially?

Buffered.

Normally, yes, and that's why we have something like
mysql_unbuffere d_query() :)
--
Rik Wasmus

[The Natural Philosopher]

Rik Wasmus wrote:

On Fri, 04 Jan 2008 08:52:28 +0100, The Natural Philosopher <[e-mail]:

>howa wrote:

>>On 1$B7n(B4$BF| (B, $B>e8a(B2$B; ~(B04$BJ,(B, Jerry Stuckle
<jstuck...@at tglobal.netwrot e:
howa wrote:
For example,
$query = "SELECT ...'";
$res = mysql_query($qu ery);
while($ro w = mysql_fetch_ass oc($res)) {
// Do sth
}
If the query return say over 1M row, is it limited by the MySQL server
or PHP ?
There is no hard limit in either. Rather, system resources would
probably be your limiting factor.

--
For example, will mysql store all the 1M rows in a buffer, or it will
be fetched sequentially?

Buffered.

Normally, yes, and that's why we have something like
mysql_unbuffere d_query() :)

Do we? live and learn eh?

[Jerry Stuckle]

The Natural Philosopher wrote:

howa wrote:

>On 1$B7n(B4$BF| (B, $B>e8a(B2$B; ~(B04$BJ,(B, Jerry Stuckle
<jstuck...@att global.netwrote :

>>howa wrote:
For example,
$query = "SELECT ...'";
$res = mysql_query($qu ery);
while($row = mysql_fetch_ass oc($res)) {
// Do sth
}
If the query return say over 1M row, is it limited by the MySQL server
or PHP ?
There is no hard limit in either. Rather, system resources would
probably be your limiting factor.

--

For example, will mysql store all the 1M rows in a buffer, or it will
be fetched sequentially?

Buffered.

Not necessarily. It's why I recommended comp.databases. mysql - for a
CORRECT answer.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[Jerry Stuckle]

The Natural Philosopher wrote:

Jerry Stuckle wrote:

>howa wrote:

>>For example,

$query = "SELECT ...'";
$res = mysql_query($qu ery);
while($row = mysql_fetch_ass oc($res)) {
// Do sth
}
If the query return say over 1M row, is it limited by the MySQL server
or PHP ?

There is no hard limit in either. Rather, system resources would
probably be your limiting factor.

Its set soemwhere in PHP.INI..there is a memory limit to what PHP will
use. 16Mbyte default IIRC. Mines at 64Mbyte and I managed to pull a
25Mbyte BLOB in and out of the database.

Which has absolutely nothing to do with MySQL buffering.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===