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 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 Pentium II 350 MHz and that takes at most half a > second (although I'm doing really simple statistical stuff). > > Cheers, > > Marco > -- > ------------ > 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! > > ------------------------------------------------------------------------ > > Subject: [PHP] Resource limit/performance questions > Date: Fri, 20 Dec 2002 15:31:58 -0500 > From: John Hinton <[EMAIL PROTECTED]> > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > > I'm working on a php/mysql ap, which looks as though it will be dealing > with an average of > > 160,000 rows of short text entries = > 32 megs of drives space > > Anybody have ideas about what if any limits I might hit? And how I might > be able to determine any limits at this point when we have only 2 weeks > (.6 megs and 2600 rows) of what will be 2 years of data? I have full > access to my linux server. I notice that when executing one set of > statements for one page, it is now using in the 80 to 90% range of CPU > states, and works for maybe 3 or 4 seconds to return the querys. I am at > present doing this testing on a 550 mhz processor, but will be running > the ap on a dual 500s. > > Am I getting totally out of hand in thinking I can do this? > > TIA > -- > John Hinton - Goshen, VA. > http://www.ew3d.com > > Those who dance are considered insane > by those who can't hear the music.... > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > ------------------------------------------------------------------------ > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- John Hinton - Goshen, VA. http://www.ew3d.com Those who dance are considered insane by those who can't hear the music.... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
