|
Posted by howa on 01/04/08 03:53
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?
Navigation:
[Reply to this message]
|