I was wondering if this would grow linearly... as the data collects? So, if it takes 3 seconds to do 2600 rows, will it take 30 seconds to do 26000 rows? I am using a simple for statement to send the 26 records through the 10 querys.
A typical select is: SELECT DISTINCT DATE_FORMAT(date, '%Y%m%d'), field2 FROM $table WHERE field2 NOT LIKE '$anoption' AND field3 LIKE '$field2[$i]' AND TO_DAYS(NOW()) - TO_DAYS(date) <= 30"; This select is run over with five different date <= numbers... then done without the DISTINCT again over the same five time periods. The array of records being sent through the 10 querys should not grow too very large (26 in fact is a fairly high representation of what would be average), whereas the number of records will grow at a fairly predictable rate, with the same basic number of records added each day. I should have said records, instead of objects. (too many sessions with crAccess, too little time talking to real people about databases) Now... would you spell that querys or queries? Marco Tabini wrote: > > 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 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: Re: [PHP] Resource limit/performance questions > Date: Fri, 20 Dec 2002 15:47:07 -0500 > From: John Hinton <[EMAIL PROTECTED]> > To: Marco Tabini <[EMAIL PROTECTED]> > CC: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > References: <[EMAIL PROTECTED]> > <[EMAIL PROTECTED]> > > 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 > > ------------------------------------------------------------------------ > -- > 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
