On Thu, Oct 27, 2011 at 09:17:21PM -0500, tamouse mailing lists wrote:
> That said, I think there must be a way to do this in SQL.
Absolutely, there's a way to do this in SQL;
"select contract, sum(1) from test_table group by contract"
But as I said, simply counting is not the intent of the actual
processing that will be done.
I need to find a method that can iterate through a large number
of records and process each record (in whatever way I choose to
define) without running out of RAM. I only need to access one
record at a time, so I thought this would be pretty trivial,
and was surprised to find that the routine ran out of memory.
This simple counting exercise is merely a test of the loop
algorithm so that I can do a 'cmp' or 'diff' comparison of the
output of the PHP versus the output of the SQL to verify that in
fact the PHP algorithm is indeed finding and processing each
record (and thus arriving at the same per-contract counts that
the SQL statement does).
I will experiment with your suggestions.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php