|
|
Posted by Rik Wasmus on 01/04/08 09:54
On Fri, 04 Jan 2008 08:52:28 +0100, The Natural Philosopher <a@b.c> wrot=
e:
> howa wrote:
>> On 1=1B$B7n=1B(B4=1B$BF|=1B(B, =1B$B>e8a=1B(B2=1B$B;~=1B(B04=1B$BJ,=1B=
(B, Jerry Stuckle =
>> <jstuck...@attglobal.net> wrote:
>>> howa wrote:
>>>> For example,
>>>> $query =3D "SELECT ...'";
>>>> $res =3D mysql_query($query);
>>>> while($row =3D mysql_fetch_assoc($res)) {
>>>> // Do sth
>>>> }
>>>> If the query return say over 1M row, is it limited by the MySQL ser=
ver
>>>> 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 wil=
l
>> be fetched sequentially?
>>
> Buffered.
Normally, yes, and that's why we have something like =
mysql_unbuffered_query() :)
-- =
Rik Wasmus
Navigation:
[Reply to this message]
|