|
Posted by Jerry Stuckle on 01/04/08 13:15
The Natural Philosopher wrote:
> Jerry Stuckle 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.
>>
> 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.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|