Re: [PHP] Resource limit/performance questions

2002-12-20 Thread Marco Tabini
> > php|architect - The Magazine for PHP Professionals > The monthly magazine dedicated to the world of PHP programming > > Check us out on the web at http://www.phparch.com! > > -------- > > Subje

Re: [PHP] Resource limit/performance questions

2002-12-20 Thread John Hinton
nthly magazine dedicated to the world of PHP programming > > Check us out on the web at http://www.phparch.com! > > -------- > > Subject: Re: [PHP] Resource limit/performance questions > Date: Fri, 20 Dec 2002 1

Re: [PHP] Resource limit/performance questions

2002-12-20 Thread Marco Tabini
Well, then, assuming your complexity grows linearly, I guess you'll have to wait a few minutes with 160,000 rows on which you can expect to perform 16,000 queries... You mention that you perform the queries on objects--can you elaborate on this point? Marco -- php|architect - The M

Re: [PHP] Resource limit/performance questions

2002-12-20 Thread John Hinton
In one main instance, I'm doing 10 querys on an array of 26 unique objects extracted from the database. So, I suppose it is running 260 queries on 2600 lines of code. Marco Tabini wrote: > > IMHO it depends on the amount of operations you have to perform on your > rows. If manipulating 2,600 rows

Re: [PHP] Resource limit/performance questions

2002-12-20 Thread Marco Tabini
IMHO it depends on the amount of operations you have to perform on your rows. If manipulating 2,600 rows takes several seconds, then either you're performing some really complicated data manipulation or your db could use some optimization. I have an application that manipulates ~150,000 rows on a P