[KLUG Members] Best way to use temp files in PHP

Peter Buxton members@kalamazoolinux.org
Mon, 9 Sep 2002 11:18:10 -0400


On Mon, Sep 09, 2002 at 09:56:22AM -0400, adam@morrison-ind.com wrote:

> internall it holds all this information in an array.  So I've got a
> report with 15 columns of various types, and a heck of alot of rows.
> At about ~40,000 rows I hear "Ahhhhhhhhhhhhhhhhhhhhhhhhhhhh!" as a
> temporal rift occurs to some hell dimension and my PHP process topples
> into it.  So I'm thinking I just can't have arrays that big.

I don't suppose you can use something, such as PostgreSQL or db3,
which is used to handling +40,000 somethings, and use PHP as a parser
over it.  Any processing you need done on that data could also be stored
as MySQL data and yanked out as needed.

If PHP can't, well, then.... For me, the greatest thing about bash (or
your preferred shell) is the backtick operator -- take the data from
this program and plug it into this other program, but not as data, but
as commands. Of course, the backtick is just a pipe in a different
direction. :-)

-- 
http://www.killdevil.org/~peter