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