|
|
Posted by The Natural Philosopher on 01/04/08 07:52
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.
Navigation:
[Reply to this message]
|