|
|
Posted by Jerry Stuckle on 01/04/08 04:08
howa wrote:
> On 1月4日, 上午2時04分, 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?
>
>
>
For MySQL specific information, try comp.databases.mysql.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|