Re: [GENERAL] Large Result and Memory Limit

2007-10-04 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bill Moran wrote: > In response to "Scott Marlowe" <[EMAIL PROTECTED]>: > The process is, web interface -> request export -> get an estimate > on completion time -> come back later and check the status -> download > if complete. > > It's difficult (m

Re: [GENERAL] Large Result and Memory Limit

2007-10-04 Thread Bill Moran
In response to "Scott Marlowe" <[EMAIL PROTECTED]>: > On 10/4/07, Mike Ginsburg <[EMAIL PROTECTED]> wrote: > > > export it. Memory limit is a major concern, but the query for one row > > returns a result set too large and PHP fails. > > If this is true, and one single db row makes php exceed it

Re: [GENERAL] Large Result and Memory Limit

2007-10-04 Thread Scott Marlowe
On 10/4/07, Mike Ginsburg <[EMAIL PROTECTED]> wrote: > This is for the export only. Since it is an export of ~50,000 registrants, > it takes some time to process. We also have load balanced web servers, so > unless I want to create identical processes on all webservers, or write some > crazy sc

Re: [GENERAL] Large Result and Memory Limit

2007-10-04 Thread Mike Ginsburg
Scott Marlowe wrote: On 10/4/07, Mike Ginsburg <[EMAIL PROTECTED]> wrote: export it. Memory limit is a major concern, but the query for one row returns a result set too large and PHP fails. If this is true, and one single db row makes php exceed its memory limit just by returning it,

Re: [GENERAL] Large Result and Memory Limit

2007-10-04 Thread Scott Marlowe
On 10/4/07, Mike Ginsburg <[EMAIL PROTECTED]> wrote: > export it. Memory limit is a major concern, but the query for one row > returns a result set too large and PHP fails. If this is true, and one single db row makes php exceed its memory limit just by returning it, you've done something very v

Re: [GENERAL] Large Result and Memory Limit

2007-10-04 Thread Alvaro Herrera
Scott Marlowe escribió: > On 10/4/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > Mike Ginsburg wrote: > > > Hello, > > > I am working on a personnel registry that has upwards of 50,000 > > > registrants. Currently I am working on an export module that will create > > > a > > > CSV from multip

Re: [GENERAL] Large Result and Memory Limit

2007-10-04 Thread Scott Marlowe
On 10/4/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Mike Ginsburg wrote: > > Hello, > > I am working on a personnel registry that has upwards of 50,000 > > registrants. Currently I am working on an export module that will create a > > CSV from multiple tables. I have managed to keep the scri

Re: [GENERAL] Large Result and Memory Limit

2007-10-04 Thread André Volpato
Alvaro Herrera escreveu: Mike Ginsburg wrote: Hello, I am working on a personnel registry that has upwards of 50,000 registrants. Currently I am working on an export module that will create a CSV from multiple tables. I have managed to keep the script (PHP) under the memory l

Re: [GENERAL] Large Result and Memory Limit

2007-10-04 Thread André Volpato
Mike Ginsburg escreveu: André Volpato wrote: Mike Ginsburg escreveu: Hello, I am working on a personnel registry that has upwards of 50,000 registrants. Currently I am working on an export module that will create a CSV from multiple tables. I have managed to keep the script (PHP) under th

Re: [GENERAL] Large Result and Memory Limit

2007-10-04 Thread Alvaro Herrera
Mike Ginsburg wrote: > Hello, > I am working on a personnel registry that has upwards of 50,000 > registrants. Currently I am working on an export module that will create a > CSV from multiple tables. I have managed to keep the script (PHP) under > the memory limit when creating and inserting

Re: [GENERAL] Large Result and Memory Limit

2007-10-04 Thread Mike Ginsburg
André Volpato wrote: Mike Ginsburg escreveu: Hello, I am working on a personnel registry that has upwards of 50,000 registrants. Currently I am working on an export module that will create a CSV from multiple tables. I have managed to keep the script (PHP) under the memory limit okay...

Re: [GENERAL] Large Result and Memory Limit

2007-10-04 Thread André Volpato
Mike Ginsburg escreveu: Hello, I am working on a personnel registry that has upwards of 50,000 registrants. Currently I am working on an export module that will create a CSV from multiple tables. I have managed to keep the script (PHP) under the memory limit okay... some info needed here.

[GENERAL] Large Result and Memory Limit

2007-10-04 Thread Mike Ginsburg
Hello, I am working on a personnel registry that has upwards of 50,000 registrants. Currently I am working on an export module that will create a CSV from multiple tables. I have managed to keep the script (PHP) under the memory limit when creating and inserting the CSV into the database.