Re: Large table doesn't display

Hi Dave Hmm, I'm assuming the table is indexed properly (i.e. it has indices that the query can use), and that the table and indices are not corrupt (you can check using myisamchk)? Can you post the table definition and the query? Shane On Monday 05 November 2001 8:07 pm, Dave Pollak wrote: > 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