RE: [PHP-DB] Large table doesn't display

Shane, Yes, I would like to know why this is happening. Watched performance monitor and network monitor (not at the same time) as I ran this query a couple of times. Did not use much processor, memory, or hard disk although the processor usage would spike upon receipt of the query. Nor did it seem to be hogging my bandwidth. No long text or binary fields to get rid of. However, reduced the number or fields returned and performance improved dramatically. 2 fields and performance is within tolerable limits. 4 fields and it is not. Its not enough data to run the report but it's a clue....I hope. BTW, this function "$num_results = mysql_num_rows($result);" works instantly. dp -----Original Message----- From: Shane Wright [mailto:me@shanewright.co.uk] Sent: Monday, November 05, 2001 2:27 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Large table doesn't display Hi Dave Lasar's solution will probs work, but its worth trying to find out why this is happening (needless to say, it shouldn't...) It looks like the server is running out of memory. Does the hard drive start thrashing when running the 10,000 result query? If so, try reducing the amount of memory used by other processes and optimising your query to only process/use the fields/records required. It may help to split the table into two - one for the lookups like that and one to hold all the important data (this will help more if you have text or binary fields in the table). Regards -- Shane On Monday 05 November 2001 6:51 pm, Dave Pollak wrote: > Howdy, > > I've got a table with over 11,000 records that I want to display and print. > I'm running an intranet with mySQL and PHP4 on NT4.0 sp6a. Queries that > return even up to 5000 records are pretty snappy. 7500 or more records are > returned with only a slight delay. 10,000 or more just stop. I've got to > print the whole list. My users don't want to print a page at a time. > > Dave Pollak -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net