You are here: Re: How large is the mysql_query() buffer? « PHP Programming Language « IT news, forums, messages
Re: How large is the mysql_query() buffer?

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация