|
|
Posted by The Natural Philosopher on 01/04/08 11:14
Rik Wasmus wrote:
> On Fri, 04 Jan 2008 08:52:28 +0100, The Natural Philosopher <a@b.c> wrote:
>
>> howa wrote:
>>> On 1$B7n(B4$BF|(B, $B>e8a(B2$B;~(B04$BJ,(B, Jerry Stuckle
>>> <jstuck...@attglobal.net> wrote:
>>>> howa wrote:
>>>>> For example,
>>>>> $query = "SELECT ...'";
>>>>> $res = mysql_query($query);
>>>>> while($row = mysql_fetch_assoc($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_unbuffered_query() :)
Do we? live and learn eh?
Navigation:
[Reply to this message]
|