Posted by Jerry Stuckle on 01/04/08 13:14

The Natural Philosopher 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.
>

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.
jstucklex@attglobal.net
==================

• Next in forum: Re: How large is the mysql_query() buffer?
• Prev in forum: Re: Post with redirect?
• Thread view: Re: How large is the mysql_query() buffer?

[Reply to this message]