On Fri, Oct 28, 2011 at 01:21:36PM -0400, Eric Butera wrote:
> On Fri, Oct 28, 2011 at 12:38 PM, Jim Long <php@xxxxxxxxxxxxx> wrote:
> > I'm running PHP 5.3.8 on FreeBSD 8.2 with MySQL 5.1.55.
> >
> > The script below is designed to be able to WHILE it's way through
> > a MySQL query result set, and process each row.
> >
> > However, it runs out of memory a little after a quarter million
> > rows. ??The schema fields total to about 200 bytes per row, so
> > the row size doesn't seem very large.
> >
> > Why is this running out of memory?
> >
> > Thank you!
> >
> > Jim
> >
> > <?php
> >
> > $test_db_host = "localhost";
> > $test_db_user = "foo";
> > $test_db_pwd ??= "bar";
> > $test_db_name = "farkle";
> >
> > $db_host = $test_db_host;
> > $db_user = $test_db_user;
> > $db_name = $test_db_name;
> > $db_pwd ??= $test_db_pwd;
> >
> > if (!($db_conn = mysql_connect( $db_host, $db_user, $db_pwd )))
> > ?? ?? ?? ??die( "Can't connect to MySQL server\n" );
> >
> > if (!mysql_select_db( $db_name, $db_conn ))
> > ?? ?? ?? ??die( "Can't connect to database $db_name\n" );
> >
> > $qry = "select * from test_table order by contract";
> >
> > if ($result = mysql_query( $qry, $db_conn )) {
> >
> > ?? ?? ?? ??$n = 0;
> > ?? ?? ?? ??while ($row = mysql_fetch_assoc( $result )) {
> > // process row here
> > ?? ?? ?? ?? ?? ?? ?? ??$n++;
> > ?? ?? ?? ??} // while
> >
> > ?? ?? ?? ??mysql_free_result($result);
> > ?? ?? ?? ??echo "$n\n";
> >
> > } else {
> >
> > ?? ?? ?? ??die( mysql_error() . "\n" );
> >
> > }
> >
> > ?>
> >
> >
> > PHP Fatal error: ??Allowed memory size of 134217728 bytes exhausted (tried to allocate 20 bytes) in xx3.php on line 24
> >
> > Line 24 is:
> >
> > ?? ??24 ?? ?? ?? ?? ??while ($row = mysql_fetch_assoc( $result )) {
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
> Not sure what is happening inside "process row here," but I'm sure
> that is where your issue is. Instead of building some giant structure
> inside of that while statement you should flush it out to the screen.
Eric:
Thanks for your reply.
"process row here" is a comment. It doesn't do anything. The
script, exactly as shown, runs out of memory, exactly as shown.
Jim
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
